This appendix describes files distributed with the database that demonstrate how LOBs are used in supported programmatic environments. This appendix contains these topics:
The following table lists PL/SQL demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/plsql/
. A driver program, lobdemo.sql
, that calls these files is found in the same directory.
Table A-1 PL/SQL Demonstration Examples
File Name | Description | Usage Information |
---|---|---|
fclose_c.sql |
Closing a BFILE with CLOSE |
Closing a BFILE with CLOSE |
fclose_f.sql |
Closing a BFILE with FILECLOSE |
Closing a BFILE with FILECLOSE |
fclosea.sql |
Closing all open BFILE s |
Closing All Open BFILEs with FILECLOSEALL |
fcompare.sql |
Comparing all or parts of two BFILE s |
Comparing All or Parts of Two BFILES |
fcopyloc.sql |
Copying a LOB locator for a BFILE |
Assigning a BFILE Locator |
fdisplay.sql |
Displaying BFILE data |
Displaying BFILE Data |
fexists.sql |
Checking if a BFILE exists |
Determining Whether a BFILE Exists |
ffilopen.sql |
Opening a BFILE with FILEOPEN |
Opening a BFILE with FILEOPEN |
ffisopen.sql |
Checking if the BFILE is OPEN with FILEISOPEN |
Determining Whether a BFILE Is Open with FILEISOPEN |
fgetdir.sql |
Getting the directory object name and filename of a BFILE |
Getting Directory Object Name and File Name of a BFILE |
finsert.sql |
Inserting row containing a BFILE by initializing a BFILE locator |
Inserting a Row Containing a BFILE |
fisopen.sql |
Checking if the BFILE is open with ISOPEN |
Determining Whether a BFILE Is Open Using ISOPEN |
flength.sql |
Getting the length of a BFILE |
Getting the Length of a BFILE |
floadlob.sql |
Loading a LOB with BFILE data |
Loading a LOB with BFILE Data |
fopen.sql |
Opening a BFILE with OPEN |
Opening a BFILE with OPEN |
fpattern.sql |
Checking if a pattern exists in a BFILE using instr |
Checking If a Pattern Exists in a BFILE Using INSTR |
fread.sql |
Reading data from a BFILE |
Reading Data from a BFILE |
freadprt.sql |
Reading portion of a BFILE data using substr |
Reading a Portion of BFILE Data Using SUBSTR |
fupdate.sql |
Updating a BFILE by initializing a BFILE locator |
Updating a BFILE by Initializing a BFILE Locator |
lappend.sql |
Appending one LOB to another | Appending One LOB to Another |
lcompare.sql |
Comparing all or part of LOB | Comparing All or Part of Two LOBs |
lcopy.sql |
Copying all or part of a LOB to another LOB | Copying All or Part of One LOB to Another LOB |
lcopyloc.sql |
Copying a LOB locator | Copying All or Part of One LOB to Another LOB |
ldisplay.sql |
Displaying LOB data | Displaying LOB Data |
lerase.sql |
Erasing part of a LOB | Erasing Part of a LOB |
linsert.sql |
Inserting a row by initializing LOB locator bind variable | Inserting a Row by Initializing a LOB Locator Bind Variable |
linstr.sql |
Seeing if pattern exists in LOB (instr) | Patterns: Checking for Patterns in a LOB Using INSTR |
lisopen.sql |
Seeing if LOB is open | Determining Whether a LOB is Open |
listemp.sql |
Seeing if LOB is temporary | Determining Whether a LOB instance Is Temporary |
lldblobf.sql |
Using DBMS_LOB.LOADBLOBFROMFILE to load a BLOB with data from a BFILE |
Loading a BLOB with Data from a BFILE |
lldclobf.sql |
Using DBMS_LOB.LOADCLOBFROMFILE to load a CLOB or NCLOB with data from a BFILE |
Loading a CLOB or NCLOB with Data from a BFILE |
lldclobs.sql |
Using DBMS_LOB.LOADCLOBFROMFILE to load segments of a stream of data from a BFILE into different CLOB s |
Loading a CLOB or NCLOB with Data from a BFILE |
llength.sql |
Getting the length of a LOB | Length: Determining the Length of a LOB |
lloaddat.sql |
Loading a LOB with BFILE data |
Loading a LOB with Data from a BFILE |
lobuse.sql |
Examples of LOB API usage. | Creating Persistent and Temporary LOBs in PL/SQL |
lread.sql |
Reading data from LOB | Reading Data from a LOB |
lsubstr.sql |
Reading portion of LOB (substr) | Reading a Portion of a LOB (SUBSTR) |
ltrim.sql |
Trimming LOB data | Trimming LOB Data |
lwrite.sql |
Writing data to a LOB | Writing Data to a LOB |
lwriteap.sql |
Writing to the end of LOB (write append) | Appending to a LOB |
The following table lists OCI demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/oci/
. A driver program, lobdemo.c
, that calls these files is found in the same directory, as is the header file lobdemo.h
.
Table A-2 OCI Demonstration Examples
File Name | Description | Usage Information |
---|---|---|
fclose_c.c |
Closing a BFILE with CLOSE |
Closing a BFILE with CLOSE |
fclose_f.c |
Closing a BFILE with FILECLOSE |
Closing a BFILE with FILECLOSE |
fclosea.c |
Closing all open BFILE s |
Closing All Open BFILEs with FILECLOSEALL |
fcopyloc.c |
Copying a LOB locator for a BFILE |
Assigning a BFILE Locator |
fdisplay.c |
Displaying BFILE data |
Displaying BFILE Data |
fexists.c |
Checking if a BFILE exists |
Determining Whether a BFILE Exists |
ffilopen.c |
Opening a BFILE with FILEOPEN |
Opening a BFILE with FILEOPEN |
ffisopen.c |
Checking if the BFILE is OPEN with FILEISOPEN |
Determining Whether a BFILE Is Open with FILEISOPEN |
fgetdir.c |
Getting the directory object name and filename of a BFILE |
Getting Directory Object Name and File Name of a BFILE |
finsert.c |
Inserting row containing a BFILE by initializing a BFILE locator |
Inserting a Row Containing a BFILE |
fisopen.c |
Checking if the BFILE is open with ISOPEN |
Determining Whether a BFILE Is Open Using ISOPEN |
flength.c |
Getting the length of a BFILE |
Getting the Length of a BFILE |
floadlob.c |
Loading a LOB with BFILE data |
Loading a LOB with BFILE Data |
fopen.c |
Opening a BFILE with OPEN |
Opening a BFILE with OPEN |
fread.c |
Reading data from a BFILE |
Reading Data from a BFILE |
fupdate.c |
Updating a BFILE by initializing a BFILE locator |
Updating a BFILE by Initializing a BFILE Locator |
lappend.c |
Appending one LOB to another | Appending One LOB to Another |
lcopy.c |
Copying all or part of a LOB to another LOB | Copying All or Part of One LOB to Another LOB |
lcopyloc.c |
Copying a LOB locator | Copying All or Part of One LOB to Another LOB |
ldisbuf.c |
Disabling LOB buffering (persistent LOBs) | Disabling LOB Buffering |
ldisplay.c |
Displaying LOB data | Displaying LOB Data |
lequal.c |
Seeing if one LOB locator is equal to another | Equality: Checking If One LOB Locator Is Equal to Another |
lerase.c |
Erasing part of a LOB | Erasing Part of a LOB |
lgetchar.c |
Getting character set id | Determining Character Set ID |
lgetchfm.c |
Getting character set form of the foreign language ad text, ad_fltextn |
Determining Character Set Form |
linit.c |
Seeing if a LOB locator is initialized | Determining Whether LOB Locator Is Initialized |
linsert.c |
Inserting a row by initializing LOB locator bind variable | Inserting a Row by Initializing a LOB Locator Bind Variable |
lisopen.c |
Seeing if LOB is open | Determining Whether a LOB is Open |
listemp.c |
Seeing if LOB is temporary | Determining Whether a LOB instance Is Temporary |
llength.c |
Getting the length of a LOB | Length: Determining the Length of a LOB |
lloaddat.c |
Loading a LOB with BFILE data |
Loading a LOB with Data from a BFILE |
lread.c |
Reading data from LOB | Reading Data from a LOB |
lreadarr.c |
Reading data from an array of LOB locators | LOB Array Read |
ltrim.c |
Trimming LOB data | Trimming LOB Data |
lwrite.c |
Writing data to a LOB | Writing Data to a LOB |
lwritearr.c |
Writing data into an array of LOB locators | LOB Array Write |
lwriteap.c |
Writing to the end of LOB (write append) | Appending to a LOB |
The following table lists Visual Basic OO4O demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/vb/
.
Table A-3 Visual Basic OO4O Demonstration Examples
File Name | Description | Usage Information |
---|---|---|
fclose_c.bas |
Closing a BFILE with CLOSE |
Closing a BFILE with CLOSE |
fclosea.bas |
Closing all open BFILE s |
Closing All Open BFILEs with FILECLOSEALL |
fcompare.bas |
Comparing all or parts of two BFILE s |
Comparing All or Parts of Two BFILES |
fdisplay.bas |
Displaying BFILE data |
Displaying BFILE Data |
fexists.bas |
Checking if a BFILE exists |
Determining Whether a BFILE Exists |
fgetdir.bas |
Getting the directory object name and filename of a BFILE |
Getting Directory Object Name and File Name of a BFILE |
finsert.bas |
Inserting row containing a BFILE by initializing a BFILE locator |
Inserting a Row Containing a BFILE |
fisopen.bas |
Checking if the BFILE is open with ISOPEN |
Determining Whether a BFILE Is Open Using ISOPEN |
flength.bas |
Getting the length of a BFILE |
Getting the Length of a BFILE |
floadlob.bas |
Loading a LOB with BFILE data |
Loading a LOB with BFILE Data |
fopen.bas |
Opening a BFILE with OPEN |
Opening a BFILE with OPEN |
fread.bas |
Reading data from a BFILE |
Reading Data from a BFILE |
freadprt.bas |
Reading portion of a BFILE data using substr |
Reading a Portion of BFILE Data Using SUBSTR |
fupdate.bas |
Updating a BFILE by initializing a BFILE locator |
Updating a BFILE by Initializing a BFILE Locator |
lappend.bas |
Appending one LOB to another | Appending One LOB to Another |
lcompare.bas |
Comparing all or part of LOB | Comparing All or Part of Two LOBs |
lcopy.bas |
Copying all or part of a LOB to another LOB | Copying All or Part of One LOB to Another LOB |
lcopyloc.bas |
Copying a LOB locator | Copying All or Part of One LOB to Another LOB |
ldisbuf.bas |
Disabling LOB buffering (persistent LOBs) | Disabling LOB Buffering |
ldisplay.bas |
Displaying LOB data | Displaying LOB Data |
lenbuf.bas |
Enabling LOB buffering | Enabling LOB Buffering |
lerase.bas |
Erasing part of a LOB | Erasing Part of a LOB |
linsert.bas |
Inserting a row by initializing LOB locator bind variable | Inserting a Row by Initializing a LOB Locator Bind Variable |
llength.bas |
Getting the length of a LOB | Length: Determining the Length of a LOB |
lloaddat.bas |
Loading a LOB with BFILE data | Loading a LOB with Data from a BFILE |
lread.bas |
Reading data from LOB | Reading Data from a LOB |
lsubstr.bas |
Reading portion of LOB (substr) | Reading a Portion of a LOB (SUBSTR) |
ltrim.bas |
Trimming LOB data | Trimming LOB Data |
lwrite.bas |
Writing data to a LOB | Writing Data to a LOB |
The following table lists Java demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/java/
.
Table A-4 Java Demonstration Examples
File Name | Description | Usage Information |
---|---|---|
fclose_c.java |
Closing a BFILE with CLOSE |
Closing a BFILE with CLOSE |
fclose_f.java |
Closing a BFILE with FILECLOSE |
Closing a BFILE with FILECLOSE |
fclosea.java |
Closing all open BFILE s |
Closing All Open BFILEs with FILECLOSEALL |
fcompare.java |
Comparing all or parts of two BFILE s |
Comparing All or Parts of Two BFILES |
fcopyloc.java |
Copying a LOB locator for a BFILE |
Assigning a BFILE Locator |
fdisplay.java |
Displaying BFILE data |
Displaying BFILE Data |
fexists.java |
Checking if a BFILE exists |
Determining Whether a BFILE Exists |
ffilopen.java |
Opening a BFILE with FILEOPEN |
Opening a BFILE with FILEOPEN |
ffisopen.java |
Checking if the BFILE is OPEN with FILEISOPEN |
Determining Whether a BFILE Is Open with FILEISOPEN |
fgetdir.java |
Getting the directory object name and filename of a BFILE |
Getting Directory Object Name and File Name of a BFILE |
finsert.java |
Inserting row containing a BFILE by initializing a BFILE locator |
Inserting a Row Containing a BFILE |
fisopen.java |
Checking if the BFILE is open with ISOPEN |
Determining Whether a BFILE Is Open Using ISOPEN |
flength.java |
Getting the length of a BFILE |
Getting the Length of a BFILE |
fopen.java |
Opening a BFILE with OPEN |
Opening a BFILE with OPEN |
fpattern.java |
Checking if a pattern exists in a BFILE using instr |
Checking If a Pattern Exists in a BFILE Using INSTR |
fread.java |
Reading data from a BFILE |
Reading Data from a BFILE |
freadprt.java |
Reading portion of a BFILE data using substr |
Reading a Portion of BFILE Data Using SUBSTR |
fupdate.java |
Updating a BFILE by initializing a BFILE locator |
Updating a BFILE by Initializing a BFILE Locator |
lappend.java |
Appending one LOB to another | Appending One LOB to Another |
lcompare.java |
Comparing all or part of LOB | Comparing All or Part of Two LOBs |
lcopy.java |
Copying all or part of a LOB to another LOB | Copying All or Part of One LOB to Another LOB |
lcopyloc.java |
Copying a LOB locator | Copying All or Part of One LOB to Another LOB |
ldisplay.java |
Displaying LOB data | Displaying LOB Data |
lequal.java |
Seeing if one LOB locator is equal to another | Equality: Checking If One LOB Locator Is Equal to Another |
lerase.java |
Erasing part of a LOB | Erasing Part of a LOB |
linsert.java |
Inserting a row by initializing LOB locator bind variable | Inserting a Row by Initializing a LOB Locator Bind Variable |
linstr.java |
Seeing if pattern exists in LOB (instr) | Patterns: Checking for Patterns in a LOB Using INSTR |
lisopen.java |
Seeing if LOB is open | Determining Whether a LOB is Open |
listempb.java |
Seeing if LOB is temporary | Determining Whether a LOB instance Is Temporary |
listempc.java |
Seeing if LOB is temporary | Determining Whether a LOB instance Is Temporary |
llength.java |
Getting the length of a LOB | Length: Determining the Length of a LOB |
lloaddat.java |
Loading a LOB with BFILE data | Loading a LOB with Data from a BFILE |
lread.java |
Reading data from LOB | Reading Data from a LOB |
lsubstr.java |
Reading portion of LOB (substr) | Reading a Portion of a LOB (SUBSTR) |
ltrim.java |
Trimming LOB data | Trimming LOB Data |
lwrite.java |
Writing data to a LOB | Writing Data to a LOB |
lwriteap.java |
Writing to the end of LOB (write append) | Appending to a LOB |