Large Objects   «Prev 

DBMS_LOB functions

1) With the COPY() function, the content of the src_lob are copied to the dest_lob

2) With the APPEND() function, the contents of the src_lob are appended to the end of the contents of dest_lob

3) With the TRIM() function, the length of the data in the src_lob is reduced to the number of bytes specified in the function

4) With the ERASE() function, the data is erased from the src_lob, but the space is not reclaimed