December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...