Copy a large object to a large object

The following example uses the lobs table created in Figure 1.

The lld_copy function in the example copies large object data from one lld_locator type row to another.

Figure 1. Copy a large object to a large object

-- Copy an lld_locator to an lld_locator 
select lld_copy (S.lo, D.lo) from lobs S, lobs D where S.key = 1 and D.key = 2;


(expression)  ROW('IFX_CLOB      ','clob:ffffffffa6b7c8d9000000020000000300
          0000090000001a0000000000010000000000000ad3c3dc000000000b06eec8000
          00000005c4e6000607fdc000000000000000000000000',NULL) 


select lo.lo_pointer::clob from lobs where key = 2;


(expression)  
Ask not what your country can do for you,
but what you can do for your country.

The second SELECT statement casts lo.lo_pointer to a CLOB type to display the data in the column.