COPY v17

The COPY procedure copies one large object to another. The source and destination large objects must be the same data type.

COPY(<dest_lob> IN OUT { BLOB | CLOB }, <src_lob>
{ BLOB | CLOB },
  <amount> NUMBER
  [, <dest_offset> NUMBER [, <src_offset> NUMBER ]])

Parameters

dest_lob

Large object locator of the large object to which you want to copy src_lob. Must be the same data type as src_lob.

src_lob

Large object locator of the large object to copy to dest_lob. Must be the same data type as dest_lob.

amount

Number of bytes/characters of src_lob to copy.

dest_offset

Position in the destination large object where you want writing of the source large object to begin. The first position is offset 1. The default is 1.

src_offset

Position in the source large object where you want copying to the destination large object to begin. The first position is offset 1. The default is 1.