Oracle in a Nutshell

Calls

PROCEDURE DBMS_LOB.APPEND ({dest_lob IN OUT BLOB | dest_lob IN OUT CLOB CHARACTER SET ANY_CS}, {src_lob IN BLOB | src_lob IN CLOB CHARACTER SET dest_lob%CHARSET});

Appends the contents of the source LOB src_lob to the destination LOB dest_lob. Both src_lob and dest_lob must be of the same LOB type: BLOB, CLOB, or NCLOB.

PROCEDURE DBMS_LOB.CLOSE ({lob_loc IN OUT NOCOPY BLOB | lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS | file_loc IN OUT NOCOPY BFILE});

Closes a previously opened BLOB, CLOB, or external file. New with Oracle9i.

FUNCTION DBMS_LOB.COMPARE (lob_1 IN {BLOB | CLOB CHARACTER SET ANY_CS}, lob_2 IN {BLOB | CLOB CHARACTER SET lob_1%CHARSET}, amount IN INTEGER DEFAULT 4294967295, offset_1 IN INTEGER DEFAULT 1, offset_2 IN INTEGER DEFAULT 1) RETURN INTEGER; FUNCTION DBMS_LOB.COMPARE (file_1 IN BFILE, file_2 IN BFILE, amount IN INTEGER, offset_1 IN INTEGER DEFAULT 1, offset_2 IN INTEGER DEFAULT 1) RETURN INTEGER;

Compares input LOBs lob_1 and lob_2 or file_1 and file_2 across amount bytes, optionally starting the comparison offset_1 and offset_ 2 bytes into the input files. Both inputs must be of the same LOB type: BLOB, CLOB, NCLOB, or BFILE.

Returns 0 if the inputs exactly match, nonzero if they don’t match, or NULL if amount, offset_1, or offset_2 is either less than 1 or greater than LOBMAXSIZE, a constant in this package with a value of 4,294,967,295.

PROCEDURE DBMS_LOB.COPY (dest_lob IN OUT {BLOB | CLOB CHARACTER SET ANY_CS}, src_lob IN {BLOB | CLOB CHARACTER ...