A LOB Demonstration Files
This appendix describes files distributed with the database that demonstrate how LOBs are used in supported programmatic environments. This appendix contains these topics:
PL/SQL LOB Demonstration Files
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 all open |
|
|
Comparing all or parts of two |
|
|
Copying a LOB locator for a |
|
|
Displaying |
|
|
Checking if a |
|
|
Opening a |
|
|
Checking if the |
|
|
Getting the directory object name and filename of a |
|
|
Inserting row containing a |
|
|
Checking if the |
|
|
Getting the length of a |
|
|
Loading a LOB with |
|
|
Opening a |
|
|
Checking if a pattern exists in a |
|
|
Reading data from a |
|
|
Reading portion of a |
|
|
Updating a |
|
|
Appending one LOB to another |
|
|
Comparing all or part of LOB |
|
|
Copying all or part of a LOB to another LOB |
|
|
Copying a LOB locator |
|
|
Displaying LOB data |
|
|
Erasing part of a LOB |
|
|
Inserting a row by initializing LOB locator bind variable |
|
|
Seeing if pattern exists in LOB ( |
|
|
Seeing if LOB is open |
|
|
Seeing if LOB is temporary |
|
|
Using |
|
|
Using |
|
|
Using |
|
|
Getting the length of a LOB |
|
|
Loading a LOB with |
|
|
Examples of LOB API usage. |
|
|
Reading data from LOB |
|
|
Reading portion of LOB ( |
|
|
Trimming LOB data |
|
|
Writing data to a LOB |
|
|
Writing to the end of LOB (write append) |
OCI LOB Demonstration Files
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 all open |
|
|
Copying a LOB locator for a |
|
|
Displaying |
|
|
Checking if a |
|
|
Opening a BFILE with |
|
|
Checking if the |
|
|
Getting the directory object name and filename of a |
|
|
Inserting row containing a |
|
|
Checking if the |
|
|
Getting the length of a |
|
|
Loading a LOB with |
|
|
Opening a |
|
|
Reading data from a |
|
|
Updating a |
|
|
Appending one LOB to another |
|
|
Copying all or part of a LOB to another LOB |
|
|
Copying a LOB locator |
|
|
Displaying LOB data |
|
|
Seeing 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, |
|
|
Seeing if a LOB locator is initialized |
|
|
Inserting a row by initializing LOB locator bind variable |
|
|
Seeing if LOB is open |
|
|
Seeing if LOB is temporary |
|
|
Getting the length of a LOB |
|
|
Loading a LOB with |
|
|
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) |
Java LOB Demonstration Files
The following table lists Java demonstration files. These files are installed in $ORACLE_HOME/rdbms/demo/lobs/java/
.
Table A-3 Java Demonstration Examples
File Name | Description | Usage Information |
---|---|---|
|
|
See Oracle Database JDBC Developer's Guide for information on setting up your system to be able to compile and run JDBC programs with the Oracle Driver |
LobDemoConnectionFactory.java |
- |
As written |
|
Closing a |
|
|
Closing a |
|
|
Closing all open |
|
|
Comparing all or parts of two |
|
|
Checking if a |
|
|
Opening a |
|
|
Checking if the |
|
|
Getting the directory object name and filename of a |
|
|
Inserting row containing a |
|
|
Checking if the |
|
|
Getting the length of a |
|
|
Opening a |
|
|
Checking if a pattern exists in a |
|
|
Reading data from a |
|
|
Updating a |
|
|
Appending one LOB to another |
|
|
Comparing all or part of LOB |
|
|
Copying all or part of a LOB to another LOB |
|
|
Erasing part of a LOB |
|
|
Inserting a row by initializing LOB locator bind variable |
|
|
Seeing if pattern exists in LOB ( |
|
|
Seeing if LOB is open |
|
|
Seeing if LOB is temporary |
|
|
Seeing if LOB is temporary |
|
|
Getting the length of a LOB |
|
|
Loading a LOB with BFILE data |
|
|
Reading data from LOB |
|
|
Reading portion of LOB ( |
|
|
Trimming LOB data |
|
|
Writing data to a LOB |
|
|
Writing to the end of LOB (write append) |