Skip to main content
Version: Next

COPY BLOB

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

ParameterTypeDescription
srcBLOBBLOB🡒Source BLOB
dstBLOBBLOB🡒Destination BLOB
srcOffsetLongint🡒Source position for the copy
dstOffsetLongint🡒Destination position for the copy
lenLongint🡒Number 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