Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page