Skip to main content
Version: 20 R7 BETA

COPY BLOB

COPY BLOB ( srcBLOB ; dstBLOB ; srcOffset ; dstOffset ; len )

ParameterTypeDescription
srcBlobBlobSource BLOB
dstBlobBlobDestination BLOB
srcOffsetIntegerSource position for the copy
dstOffsetIntegerDestination position for the copy
lenIntegerNumber of bytes to be copied

Description

The COPY BLOB command copies the number of bytes specified by len from the BLOB srcBLOB to the BLOB dstBLOB.

The copy starts at the position (expressed relative to the beginning of the source BLOB) specified by srcOffset and takes place at the position (expressed relative to the beginning of the destination BLOB) specified by dstOffset.

Note: The destination BLOB can be resized if necessary.

See also

DELETE FROM BLOB
INSERT IN BLOB