Oracle® Database SecureFiles and Large Objects Developer's Guide 11g Release 1 (11.1) Part Number B28393-01 |
|
|
View PDF |
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 |
---|---|---|
|
Closing a |
|
|
Closing a |
Closing a BFILE with FILECLOSE |
|
Closing all open |
Closing All Open BFILEs with FILECLOSEALL |
|
Comparing all or parts of two |
Comparing All or Parts of Two BFILES |
|
Copying a LOB locator for a |
|
|
Displaying |
|
|
Checking if a |
Determining Whether a BFILE Exists |
|
Opening a |
|
|
Checking if the |
Determining Whether a BFILE Is Open with FILEISOPEN |
|
Getting the directory object name and filename of a |
Getting Directory Object Name and File Name of a BFILE |
|
Inserting row containing a |
Inserting a Row Containing a BFILE |
|
Checking if the |
Determining Whether a BFILE Is Open Using ISOPEN |
|
Getting the length of a |
|
|
Loading a LOB with |
|
|
Opening a |
|
|
Checking if a pattern exists in a |
Checking If a Pattern Exists in a BFILE Using INSTR |
|
Reading data from a |
|
|
Reading portion of a |
Reading a Portion of BFILE Data Using SUBSTR |
|
Updating a |
Updating a BFILE by Initializing a BFILE Locator |
|
Appending one LOB to another |
|
|
Comparing all or part of LOB |
Comparing All or Part of Two LOBs |
|
Copying all or part of a LOB to another LOB |
Copying All or Part of One LOB to Another LOB |
|
Copying a LOB locator |
Copying All or Part of One LOB to Another LOB |
|
Displaying LOB data |
|
|
Erasing part of a LOB |
|
|
Inserting a row by initializing LOB locator bind variable |
Inserting a Row by Initializing a LOB Locator Bind Variable |
|
Seeing if pattern exists in LOB (instr) |
Patterns: Checking for Patterns in a LOB Using INSTR |
|
Seeing if LOB is open |
Determining Whether a LOB is Open |
|
Seeing if LOB is temporary |
Determining Whether a LOB instance Is Temporary |
|
Using |
Loading a BLOB with Data from a BFILE |
|
Using |
Loading a CLOB or NCLOB with Data from a BFILE |
|
Using |
Loading a CLOB or NCLOB with Data from a BFILE |
|
Getting the length of a LOB |
Length: Determining the Length of a LOB |
|
Loading a LOB with |
Loading a LOB with Data from a BFILE |
|
Examples of LOB API usage. |
Creating Persistent and Temporary LOBs in PL/SQL |
|
Reading data from LOB |
|
|
Reading portion of LOB (substr) |
Reading a Portion of a LOB (SUBSTR) |
|
Trimming LOB data |
|
|
Writing data to a LOB |
|
|
Writing to the end of LOB (write append) |
|
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 |
---|---|---|
|
Closing a |
|
|
Closing a |
Closing a BFILE with FILECLOSE |
|
Closing all open |
Closing All Open BFILEs with FILECLOSEALL |
|
Copying a LOB locator for a |
|
|
Displaying |
|
|
Checking if a |
Determining Whether a BFILE Exists |
|
Opening a BFILE with |
|
|
Checking if the |
Determining Whether a BFILE Is Open with FILEISOPEN |
|
Getting the directory object name and filename of a |
Getting Directory Object Name and File Name of a BFILE |
|
Inserting row containing a |
Inserting a Row Containing a BFILE |
|
Checking if the |
Determining Whether a BFILE Is Open Using ISOPEN |
|
Getting the length of a |
|
|
Loading a LOB with |
|
|
Opening a |
|
|
Reading data from a |
|
|
Updating a |
Updating a BFILE by Initializing a BFILE Locator |
|
Appending one LOB to another |
|
|
Copying all or part of a LOB to another LOB |
Copying All or Part of One LOB to Another LOB |
|
Copying a LOB locator |
Copying All or Part of One LOB to Another LOB |
|
Disabling LOB buffering (persistent LOBs) |
|
|
Displaying LOB data |
|
|
Seeing if one LOB locator is equal to another |
Equality: Checking If One LOB Locator Is Equal to Another |
|
Erasing part of a LOB |
|
|
Getting character set id |
|
|
Getting character set form of the foreign language ad text, |
Determining Character Set Form |
|
Seeing if a LOB locator is initialized |
Determining Whether LOB Locator Is Initialized |
|
Inserting a row by initializing LOB locator bind variable |
Inserting a Row by Initializing a LOB Locator Bind Variable |
|
Seeing if LOB is open |
Determining Whether a LOB is Open |
|
Seeing if LOB is temporary |
Determining Whether a LOB instance Is Temporary |
|
Getting the length of a LOB |
Length: Determining the Length of a LOB |
|
Loading a LOB with |
Loading a LOB with Data from a BFILE |
|
Reading data from LOB |
|
|
Reading data from an array of LOB locators |
|
|
Trimming LOB data |
|
|
Writing data to a LOB |
|
|
Writing data into an array of LOB locators |
|
|
Writing to the end of LOB (write append) |
|
The following table lists COM OO4O demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/vb/
.
Table A-3 COM OO4O Demonstration Examples
File Name | Description | Usage Information |
---|---|---|
|
Closing a |
|
|
Closing all open |
Closing All Open BFILEs with FILECLOSEALL |
|
Comparing all or parts of two |
Comparing All or Parts of Two BFILES |
|
Displaying |
|
|
Checking if a |
Determining Whether a BFILE Exists |
|
Getting the directory object name and filename of a |
Getting Directory Object Name and File Name of a BFILE |
|
Inserting row containing a |
Inserting a Row Containing a BFILE |
|
Checking if the |
Determining Whether a BFILE Is Open Using ISOPEN |
|
Getting the length of a |
|
|
Loading a LOB with |
|
|
Opening a |
|
|
Reading data from a |
|
|
Reading portion of a |
Reading a Portion of BFILE Data Using SUBSTR |
|
Updating a |
Updating a BFILE by Initializing a BFILE Locator |
|
Appending one LOB to another |
|
|
Comparing all or part of LOB |
Comparing All or Part of Two LOBs |
|
Copying all or part of a LOB to another LOB |
Copying All or Part of One LOB to Another LOB |
|
Copying a LOB locator |
Copying All or Part of One LOB to Another LOB |
|
Disabling LOB buffering (persistent LOBs) |
|
|
Displaying LOB data |
|
|
Enabling LOB buffering |
|
|
Erasing part of a LOB |
|
|
Inserting a row by initializing LOB locator bind variable |
Inserting a Row by Initializing a LOB Locator Bind Variable |
|
Getting the length of a LOB |
Length: Determining the Length of a LOB |
|
Loading a LOB with BFILE data |
Loading a LOB with Data from a BFILE |
|
Reading data from LOB |
|
|
Reading portion of LOB (substr) |
Reading a Portion of a LOB (SUBSTR) |
|
Trimming LOB data |
|
|
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 |
---|---|---|
|
Closing a |
|
|
Closing a |
Closing a BFILE with FILECLOSE |
|
Closing all open |
Closing All Open BFILEs with FILECLOSEALL |
|
Comparing all or parts of two |
Comparing All or Parts of Two BFILES |
|
Copying a LOB locator for a |
|
|
Displaying |
|
|
Checking if a |
Determining Whether a BFILE Exists |
|
Opening a |
|
|
Checking if the |
Determining Whether a BFILE Is Open with FILEISOPEN |
|
Getting the directory object name and filename of a |
Getting Directory Object Name and File Name of a BFILE |
|
Inserting row containing a |
Inserting a Row Containing a BFILE |
|
Checking if the |
Determining Whether a BFILE Is Open Using ISOPEN |
|
Getting the length of a |
|
|
Opening a |
|
|
Checking if a pattern exists in a |
Checking If a Pattern Exists in a BFILE Using INSTR |
|
Reading data from a |
|
|
Reading portion of a |
Reading a Portion of BFILE Data Using SUBSTR |
|
Updating a |
Updating a BFILE by Initializing a BFILE Locator |
|
Appending one LOB to another |
|
|
Comparing all or part of LOB |
Comparing All or Part of Two LOBs |
|
Copying all or part of a LOB to another LOB |
Copying All or Part of One LOB to Another LOB |
|
Copying a LOB locator |
Copying All or Part of One LOB to Another LOB |
|
Displaying LOB data |
|
|
Seeing if one LOB locator is equal to another |
Equality: Checking If One LOB Locator Is Equal to Another |
|
Erasing part of a LOB |
|
|
Inserting a row by initializing LOB locator bind variable |
Inserting a Row by Initializing a LOB Locator Bind Variable |
|
Seeing if pattern exists in LOB (instr) |
Patterns: Checking for Patterns in a LOB Using INSTR |
|
Seeing if LOB is open |
Determining Whether a LOB is Open |
|
Seeing if LOB is temporary |
Determining Whether a LOB instance Is Temporary |
|
Seeing if LOB is temporary |
Determining Whether a LOB instance Is Temporary |
|
Getting the length of a LOB |
Length: Determining the Length of a LOB |
|
Loading a LOB with BFILE data |
Loading a LOB with Data from a BFILE |
|
Reading data from LOB |
|
|
Reading portion of LOB (substr) |
Reading a Portion of a LOB (SUBSTR) |
|
Trimming LOB data |
|
|
Writing data to a LOB |
|
|
Writing to the end of LOB (write append) |
|