Oracle 8i Application Developer's Guide - Large Objects (LOBs)
Release 8.1.5
A68004-01

Library
Product
Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Use Case Diagrams

1 Introduction to Working With LOBs

The LOB Datatype
Internal LOBs
External LOBs (BFILEs)
Varying-Width Character Data
DBMS_LOB Package
OCI
LOBs in Comparison to LONG and LONG RAW Types
LOB Restrictions
DBA Actions Required Prior to Working with LOBs
Set Maximum Number of Open BFILEs
Using SQL DML for Basic Operations on LOBs
Programmatic Environments for Operating on LOBs
Comparison of Six Interfaces
Using the DBMS_LOB Package for Working With LOBs
Using the Oracle Call Interface (OCI) with LOBs
Using C++ (Pro*C/C++) to Work with LOBs
Using COBOL (Pro*COBOL) to Work with LOBs
Using Visual Basic (OO4O) to Work with LOBs
Using Java (JDBC) to Work with LOBs
An Example Application
The Multimedia Content-Collection System
Applying an Object-Relational Design to the Application
The Structure of the Multimedia_tab Table
The Most Basic Operation: Getting and Using the LOB Locator
LOB Value and Locators
LOB Locator Operations
LOB Locators and Transaction Boundaries
Open, Close and IsOpen Interfaces for Internal LOBs
Indexing a LOB Column

2 Advanced Topics

Read-Consistent Locators
Updated locators
LOB Bind Variables
LOB locators cannot span transactions
LOBs in the Object Cache
LOB Buffering Subsystem
Advantages of LOB Buffering
Considerations in the Use of LOB Buffering
LOB Buffering Operations
Example of LOB Buffering
User Guidelines for Best Performance Practices
Working with Varying-Width Character Data
LOBs in Index Organized Tables

3 Internal Persistent LOBs

Use Case Model: Internal Persistent LOBs
Three Ways to Create a Table Containing a LOB
Issues to Consider in Creating Tables that Will Contain LOBs
Initializing Internal LOBs to NULL or Empty
Stipulating Tablespace and Storage Characteristics for Internal Lobs
CREATE a Table Containing One or More LOB Columns
Scenario
Example: Create a Table Containing One or More LOB Columns using SQL DDL
CREATE a Table Containing an Object Type with a LOB Attribute
Scenario
Example: Create a Table Containing an Object Type with a LOB Attribute Using SQL DDL
CREATE a Table with a Nested Table Containing a LOB
Scenario
Example: Create a Table with a Nested Table Containing a LOB Using SQL DDL
Three Ways Of Inserting One or More LOB Values into a Row
INSERT a LOB Value using EMPTY_CLOB() or EMPTY_BLOB()
Making a LOB Column Non-Null
Example: Insert a Value by means of EMPTY_CLOB() / EMPTY_BLOB() using SQL
INSERT a Row Containing a LOB as SELECT
Scenario
Example: Insert a Row by Selecting from Another Table Using SQL DML
INSERT a Row by Initializing a LOB Locator Bind Variable
Scenario
Example: Insert a Row by Initializing a LOB Locator Bind Variable Using SQL DML
Example: Insert a Row by Initializing a LOB Locator Bind Variable Using C (OCI)
Example: Insert a Row by Initializing a LOB Locator Bind Variable Using Pro*COBOL
Example: Insert a Row by Initializing a LOB Locator Bind Variable Using C++ (Pro*C/C++)
Example: Insert a Row by Initializing a LOB Locator Bind Variable Using Visual Basic (OO4O)
Example: Insert a Row by Initializing a LOB Locator Bind Variable Using Java (JDBC)
Load Data into an Internal LOB (BLOB, CLOB, NCLOB)
Scenario
LOB Data in Predetermined Size Fields
LOB Data in Delimited Fields
LOB Data in Length-value Pair Fields
One LOB per file
Predetermined Size LOBs
Delimited LOBs
Length-Value Pair Specified LOBs
Load a LOB with Data from a BFILE
Character Set Conversion
Scenario
Example: Load a LOB with Data from a BFILE Using the DBMS_LOB Package
Example: Load a LOB with Data from a BFILE Using C (OCI)
Example: Load a LOB with Data from a BFILE Using COBOL (Pro*COBOL)
Example: Load a LOB with Data from a BFILE Using C++ (Pro*C/C++)
Example: Load a LOB with Data from a BFILE Using Visual Basic (OO4O)
Example: Load a LOB with Data from a BFILE Using Java (JDBC)
See If a LOB Is Open
Scenario
Example: See If a LOB Is Open Using PL/SQL
Example: See If a LOB Is Open Using C (OCI)
Example: See If a LOB Is Open Using COBOL (Pro*COBOL)
Example: See If a LOB Is Open Using C++ (Pro*C/C++)
Example: See If a LOB Is Open Using Visual Basic (OO4O)
Example: See If a LOB Is Open Using Java (JDBC)
Copy LONG to LOB
Scenario
Example: Copy Long to LOB Using SQL
Checkout a LOB
Streaming Mechanism
Scenario
Example: CheckOut a LOB Using PL/SQL (DBMS_LOB Package)
Example: CheckOut a LOB Using C (OCI)
Example: CheckOut a LOB Using COBOL (Pro*COBOL)
Example: CheckOut a LOB Using C++ (Pro*C/C++)
Example: CheckOut a LOB Using Visual Basic (OO4O)
Example: CheckOut a LOB Using Java (JDBC)
Checkin a LOB
Streaming Mechanism
Scenario
Example: Checkin a LOB Using PL/SQL (DBMS_LOB Package)
Example: Checkin a LOB Using C (OCI)
Example: Checkin a LOB Using COBOL (Pro*COBOL)
Example: Checkin a LOB Using C++ (Pro*C/C++)
Example: Checkin a LOB Using Visual Basic (OO4O)
Example: Checkin a LOB Using Java (JDBC)
Display the LOB Data
Streaming Mechanism
Scenario
Example: Display the LOB Data Using PL/SQL
Example: Display the LOB Data Using C (OCI)
Example: Display the LOB Data Using COBOL (Pro*COBOL)
Example: Display the LOB Data Using C++ (Pro*C/C++)
Example: Display the LOB Data Using Visual Basic (OO4O)
Example: Display the LOB Data Using Java (JDBC)
Read Data from the LOB
Stream Read
Chunksize
Scenario
Example: Read Data from a LOB Using PL/SQL (DBMS_LOB Package)
Example: Read Data from a LOB Using C (OCI)
Example: Read Data from a LOB Using COBOL (Pro*COBOL)
Example: Read Data from a LOB Using C++ (Pro*C/C++)
Example: Read Data from a LOB Using Visual Basic (OO4O)
Example: Read Data from a LOB Using Java (JDBC)
Read a Portion of the LOB (substr)
Scenario
Example: Read a Portion of the LOB (substr) Using PL/SQL (DBMS_LOB Package)
Example: Read a Portion of the LOB (substr) Using COBOL (Pro*COBOL)
Example: Read a Portion of the LOB (substr) Using C++ (Pro*C/C++)
Example: Read a Portion of the LOB (substr) Using Visual Basic (OO4O)
Example: Read a Portion of the LOB (substr) Using Java (JDBC)
Compare All or Part of Two LOBs
Scenario
Example: Compare All or Part of Two LOBs Using PL/SQL (DBMS_LOB Package)
Example: Compare All or Part of Two LOBs Using COBOL (Pro*COBOL)
Example: Compare All or Part of Two LOBs Using C++ (Pro*C/C++)
Example: Compare All or Part of Two LOBs Using Visual Basic (OO4O)
Example: Compare All or Part of Two LOBs Using Java (JDBC)
See If a Pattern Exists in the LOB (instr)
Scenario
Example: See If a Pattern Exists in the LOB (instr) Using PL/SQL (DBMS_LOB Package)
Example: See If a Pattern Exists in the LOB (instr) Using COBOL (Pro*COBOL)
Example: See If a Pattern Exists in the LOB (instr) Using C++ (Pro*C/C++)
Example: See If a Pattern Exists in the LOB (instr) Using Visual Basic (OO4O)
Example: See If a Pattern Exists in the LOB (instr) Using Java (JDBC)
Get the Length of a LOB
Scenario
Example: Get the Length of a LOB Using PL/SQL (DBMS_LOB Package)
Example: Get the Length of a LOB Using C (OCI)
Example: Get the Length of a LOB Using COBOL (Pro*COBOL)
Example: Get the Length of a LOB Using C++ (Pro*C/C++)
Example: Get the Length of a LOB Using Visual Basic (OO4O)
Example: Get the Length of a LOB Using Java (JDBC)
Copy All or Part of a LOB to another LOB
Locking the Row Prior to Updating
Scenario
Example: Copy All or Part of a LOB to another LOB Using PL/SQL (DBMS_LOB Package)
Example: Copy All or Part of a LOB to another LOB Using C (OCI)
Example: Copy All or Part of a LOB to another LOB Using COBOL (Pro*COBOL)
Example: Copy All or Part of a LOB to another LOB Using C++ (Pro*C/C++)
Example: Copy All or Part of a LOB to another LOB Using Visual Basic (OO4O)
Example: Copy All or Part of a LOB to another LOB Using Java (JDBC)
Copy a LOB Locator
Scenario
Example: Copy a LOB Locator Using PL/SQL
Example: Copy a LOB Locator Using C (OCI)
Example: Copy a LOB Locator Using COBOL (Pro*COBOL)
Example: Copy a LOB Locator Using C++ (Pro*C/C++)
Example: Copy a LOB Locator Using Visual Basic (OO4O)
Example: Copy a LOB Locator Using Java (JDBC)
See If One LOB Locator Is Equal to Another
Scenario
Example: See If One LOB Locator Is Equal to Another Using C (OCI)
Example: See If One LOB Locator Is Equal to Another Using C++ (Pro*C/C++)
Example: See If One LOB Locator Is Equal to Another Using Java (JDBC)
See If a LOB Locator Is Initialized
Scenario
Example: See If a LOB Locator Is Initialized Using C (OCI)
Example: See If a LOB Locator Is Initialized Using C++ (Pro*C/C++)
Get Character Set ID
Scenario
Example: Get Character Set ID Using C (OCI)
Get Character Set Form
Scenario
Example: Get Character Set Form Using C (OCI)
Append One LOB to Another
Locking the Row Prior to Updating
Scenario
Example: Append One LOB to Another Using PL/SQL (DBMS_LOB Package)
Example: Append One LOB to Another Using C (OCI)
Example: Append One LOB to Another Using COBOL (Pro*COBOL)
Example: Append One LOB to Another Using C++ (Pro*C/C++)
Example: Append One LOB to Another Using Visual Basic (OO4O)
Example: Append One LOB to Another Using Java (JDBC)
Write Append to a LOB
Writing Singly or Piecewise
Locking the Row Prior to Updating
Scenario
Example: Write Append to a LOB Using PL/SQL
Example: Write Append to a LOB Using C (OCI)
Example: Write Append to a LOB Using COBOL (Pro*COBOL)
Example: Write Append to a LOB Using C++ (Pro*C/C++)
Example: Write Append to a LOB Using Visual Basic (OO4O)
Example: Write Append to a LOB Using Java (JDBC)
Write Data to a LOB
Stream Write
Chunksize
Locking the Row Prior to Updating
Scenario
Example: Write Data to a LOB Using the DBMS_LOB Package
Example: Write Data to a LOB Using C (OCI)
Example: Write Data to a LOB Using COBOL (Pro*COBOL)
Example: Write Data to a LOB Using C++ (Pro*C/C++)
Example: Write Data to a LOB Using Visual Basic (OO4O)
Example: Write Data to a LOB Using Java (JDBC)
Trim the LOB Data
Locking the Row Prior to Updating
Scenario
Example: Trim the LOB Data Using PL/SQL (DBMS_LOB Package)
Example: Trim the LOB Data Using C (OCI)
Example: Trim the LOB Data Using COBOL (Pro*COBOL)
Example: Trim the LOB Data Using C++ (Pro*C/C++)
Example: Trim the LOB Data Using Visual Basic (OO4O)
Example: Trim the LOB Data Using Java (JDBC)
Erase Part of a LOB
Locking the Row Prior to Updating
Scenario
Example: Erase Part of a LOB Using PL/SQL (DBMS_LOB Package)
Example: Erase Part of a LOB Using C (OCI)
Example: Erase Part of a LOB Using COBOL (Pro*COBOL)
Example: Erase Part of a LOB Using C++ (Pro*C/C++)
Example: Erase Part of a LOB Using Visual Basic (OO4O)
Example: Erase Part of a LOB Using Java (JDBC)
Enable LOB Buffering
Scenario
Example: Enable LOB Buffering Using C (OCI)
Example: Enable LOB Buffering Using COBOL (Pro*COBOL)
Example: Enable LOB Buffering Using C++ (Pro*C/C++)
Example: Enable LOB Buffering Using Visual Basic (OO4O)
Flush Buffer
Scenario
Example: Flush Buffer Using C (OCI)
Example: Flush Buffer Using COBOL (Pro*COBOL)
Example: Flush Buffer Using C++ (Pro*C/C++)
Example: Flush Buffer Using Visual Basic (OO4O)
Disable LOB Buffering
Scenario
Example: Disable LOB Buffering Using C (OCI)
Example: Disable LOB Buffering Using COBOL (Pro*COBOL)
Example: Disable LOB Buffering Using C++ (Pro*C/C++)
Example: Disable LOB Buffering Using Visual Basic (OO4O)
Three Ways to Update a LOB
UPDATE a LOB with EMPTY_CLOB() or EMPTY_BLOB()
Scenario
Example: UPDATE a LOB with EMPTY_CLOB() or EMPTY_BLOB() Using SQL
UPDATE as SELECT
Scenario
Example: Update as Select Using SQL DML
UPDATE by Initializing a LOB Locator Bind Variable
Scenario
Example: Update by Initializing a LOB Locator Bind Variable Using SQL DML
Example: Update by Initializing a LOB Locator Bind Variable Using C (OCI)
Example: Update by Initializing a LOB Locator Bind Variable Using COBOL (Pro*COBOL)
Example: Update by Initializing a LOB Locator Bind Variable Using C++ (Pro*C/C++)
Example: Update by Initializing a LOB Locator Bind Variable Using Visual Basic (OO4O)
Example: Update by Initializing a LOB Locator Bind Variable Using Java (JDBC)
DELETE the Row of a Table Containing a LOB
Scenario
Example: Delete a LOB Using SQL DML

4 Temporary LOBs

Use Case Model: Internal Temporary LOBs
Programmatic Environments
The Location of Temporary LOBs
The Lifetime and Duration of Temporary LOBs
Memory Handling
Locators and Semantics
Security Issues with Temporary LOBs
Managing Temporary LOBs
Create a Temporary LOB
Scenario
Example: Create a Temporary LOB Using PL/SQL (DBMS_LOB Package)
Example: Create a Temporary LOB Using C (OCI)
Example: Create a Temporary LOB Using COBOL (Pro*COBOL)
Example: Create a Temporary LOB Using C++ (Pro*C/C++)
See If a LOB is Temporary
Scenario
Example: See If a LOB is Temporary Using PL/SQL (DBMS_LOB Package)
Example: See If a LOB is Temporary Using C (OCI)
Example: See If a LOB is Temporary Using COBOL (Pro*COBOL)
Example: See If a LOB is Temporary Using C++ (Pro*C/C++)
Free a Temporary LOB
Scenario
Example: Free a Temporary LOB Using PL/SQL (DBMS_LOB Package)
Example: Free a Temporary LOB Using C (OCI)
Example: Free a Temporary LOB Using COBOL (Pro*COBOL)
Example: Free a Temporary LOB Using C++ (Pro*C/C++)
Load a Temporary LOB with Data from a BFILE
Scenario
Example: Load a Temporary LOB with Data from a BFILE Using PL/SQL (DBMS_LOB Package)
Example: Load a Temporary LOB with Data from a BFILE Using C (OCI)
Example: Load a Temporary LOB with Data from a BFILE Using COBOL (Pro*COBOL)
Example: Load a Temporary LOB with Data from a BFILE Using C++ (Pro*C/C++)
See If a Temporary LOB Is Open
Scenario
Example: See If a Temporary LOB Is Open Using PL/SQL
Example: See If a Temporary LOB Is Open Using C (OCI)
Example: See If a Temporary LOB Is Open Using COBOL (Pro*COBOL)
Example: See If a Temporary LOB Is Open Using C++ (Pro*C/C++)
Display the Temporary LOB Data
Scenario
Example: Display the Temporary LOB Data Using PL/SQL (DBMS_LOB Package)
Example: Display the Temporary LOB Data Using C (OCI)
Example: Display the Temporary LOB Data Using COBOL (Pro*COBOL)
Example: Display the Temporary LOB Data Using C++ (Pro*C/C++)
Read Data from a Temporary LOB
Stream Read
Scenario
Example: Read Data from a Temporary LOB Using PL/SQL (DBMS_LOB Package)
Example: Read Data from a Temporary LOB Using C (OCI)
Example: Read Data from a Temporary LOB Using COBOL (Pro*COBOL)
Example: Read Data from a Temporary LOB Using C++ (Pro*C/C++)
Read a Portion of the Temporary LOB (substr)
Scenario
Example: Read a Portion of the Temporary LOB (substr) Using PL/SQL (DBMS_LOB Package)
Example: Read a Portion of the Temporary LOB (substr) Using COBOL (Pro*COBOL)
Example: Read a Portion of the Temporary LOB (substr) Using C++ (Pro*C/C++)
Compare All or Part of Two (Temporary) LOBs
Scenario
Example: Compare All or Part of Two (Temporary) LOBs Using PL/SQL (DBMS_LOB Package)
Example: Compare All or Part of Two (Temporary) LOBs Using COBOL (Pro*COBOL)
Example: Compare All or Part of Two (Temporary) LOBs Using C++ (Pro*C/C++)
See If a Pattern Exists in a Temporary LOB (instr)
Scenario
Example: See If a Pattern Exists in a Temporary LOB (instr) Using PL/SQL (DBMS_LOB Package)
Example: See If a Pattern Exists in a Temporary LOB (instr) Using COBOL (Pro*COBOL)
Example: See If a Pattern Exists in a Temporary LOB (instr) Using C++ (Pro*C/C++)
Get the Length of a Temporary LOB
Scenario
Example: Get the Length of a Temporary LOB Using PL/SQL (DBMS_LOB Package)
Example: Get the Length of a Temporary LOB Using C (OCI)
Example: Get the Length of a Temporary LOB Using COBOL (Pro*COBOL)
Example: Get the Length of a Temporary LOB Using C++ (Pro*C/C++)
Copy All or Part of One (Temporary) LOB to Another
Scenario
Example: Copy All or Part of One (Temporary) LOB to Another Using PL/SQL (DBMS_LOB Package)
Example: Copy All or Part of One (Temporary) LOB to Another Using C (OCI)
Example: Copy All or Part of One (Temporary) LOB to Another Using COBOL (Pro*COBOL)
Example: Copy All or Part of One (Temporary) LOB to Another Using C++ (Pro*C/C++)
Copy a LOB Locator for a Temporary LOB
Scenario
Example: Copy a LOB Locator (Temporary LOBs) Using PL/SQL
Example: Copy a LOB Locator for a Temporary LOB Using C (OCI)
Example: Copy a LOB Locator for a Temporary LOB Using COBOL (Pro*COBOL)
Example: Copy a LOB Locator for a Temporary LOB Using C++ (Pro*C/C++)
See If One LOB Locator for a Temporary LOB Is Equal to Another
Scenario
Example: See If One LOB Locator for a Temporary LOB Is Equal to Another Using C (OCI)
Example: See If One LOB Locator for a Temporary LOB Is Equal to Another Using C++ (Pro*C/C++)
See If a LOB Locator for a Temporary LOB Is Initialized
Scenario
Example: See If a LOB Locator for a Temporary LOB Is Initialized Using C (OCI)
Example: See If a LOB Locator for a Temporary LOB Is Initialized Using C++ (Pro*C/C++)
Get Character Set ID of a Temporary LOB
Scenario
Example: Get Character Set ID of a Temporary LOB Using C (OCI)
Get Character Set Form of a Temporary LOB
Scenario
Example: Get Character Set Form of a Temporary LOB Using C (OCI)
Append One (Temporary) LOB to Another
Scenario
Example: Append One (Temporary) LOB to Another Using PL/SQL (DBMS_LOB Package)
Example: Append One (Temporary) LOB to Another Using C (OCI)
Example: Append One (Temporary) LOB to Another Using COBOL (Pro*COBOL)
Example: Append One (Temporary) LOB to Another Using C++ (Pro*C/C++)
Write Append to a Temporary LOB
Scenario
Example: Write Append to a Temporary LOB Using PL/SQL
Example: Write Append to a Temporary LOB Using C (OCI)
Example: Write Append to a Temporary LOB Using COBOL (Pro*COBOL)
Example: Write Append to a Temporary LOB Using C++ (Pro*C/C++)
Write Data to a Temporary LOB
Stream Write
Scenario
Example: Write Data to a Temporary LOB Using the DBMS_LOB Package
Example: Write Data to a Temporary LOB Using C (OCI)
Example: Write Data to a Temporary LOB Using COBOL (Pro*COBOL)
Example: Write Data to a Temporary LOB Using C++ (Pro*C/C++)
Trim the Temporary LOB Data
Scenario
Example: Trim the Temporary LOB Data Using PL/SQL (DBMS_LOB Package)
Example: Trim the Temporary LOB Data Using C (OCI)
Example: Trim the Temporary LOB Data Using COBOL (Pro*COBOL)
Example: Trim the Temporary LOB Data Using C++ (Pro*C/C++)
Erase Part of a Temporary LOB
Scenario
Example: Erase Part of a Temporary LOB Using PL/SQL (DBMS_LOB Package)
Example: Erase Part of a Temporary LOB Using C (OCI)
Example: Erase Part of a Temporary LOB Using COBOL (Pro*COBOL)
Example: Erase Part of a Temporary LOB Using C++ (Pro*C/C++)
Enable LOB Buffering for a Temporary LOB
Scenario
Example: Enable LOB Buffering for a Temporary LOB Using C (OCI)
Example: Enable LOB Buffering for a Temporary LOB Using COBOL (Pro*COBOL)
Example: Enable LOB Buffering for a Temporary LOB Using C++ (Pro*C/C++)
Flush Buffer for a Temporary LOB
Scenario
Example: Flush Buffer for a Temporary LOB Using C (OCI)
Example: Flush Buffer for a Temporary LOB Using COBOL (Pro*COBOL)
Example: Flush Buffer for a Temporary LOB Using C++ (Pro*C/C++)
Disable LOB Buffering for a Temporary LOB
Scenario
Example: Disable LOB Buffering Using C (OCI)
Example: Disable LOB Buffering for a Temporary LOB Using COBOL (Pro*COBOL)
Example: Disable LOB Buffering for a Temporary LOB Using C++ (Pro*C/C++)

5 External LOBs (BFILEs)

Use Case Model: External LOBs
Accessing External LOBs (SQL DML)
BFILE Security
Catalog Views on Directories
Guidelines for DIRECTORY Usage
BFILEs in Multi-Threaded Server (MTS) Mode
Three Ways to Create a Table Containing a BFILE
CREATE a Table Containing a BFILE
Scenario
Example: Create a Table Containing a BFILE Using SQL DDL
CREATE a Table of an Object Type with a BFILE Attribute
Scenario
Example: Create a Table of an Object Type with a BFILE Attribute Using SQL DDL
CREATE a Table with a Nested Table Containing a BFILE
Scenario
Example: Create a Table with a Nested Table Containing a BFILE Using SQL DDL
Three Ways to Insert a Row Containing a BFILE
INSERT a Row by means of BFILENAME()
Scenario
Example: Insert a Row by means of BFILENAME() Using SQL
Example: Insert a Row by means of BFILENAME() Using C (OCI)
Example: Insert a Row by means of BFILENAME() Using COBOL (Pro*COBOL)
Example: Insert a Row by means of BFILENAME() Using C++ (Pro*C/C++)
Example: Insert a Row by means of BFILENAME() Using Visual Basic (OO4O)
Example: Insert a Row by means of BFILENAME() Using Java (JDBC)
INSERT a Row Containing a BFILE as SELECT
Scenario
Example: Insert a Row Containing a BFILE as Select Using SQL
INSERT a Row Containing a BFILE by Initializing a BFILE Locator
Scenario
Example: Insert a Row Containing a BFILE by Initializing a BFILE Locator Using PL/SQL
Example: Insert a Row Containing a BFILE by Initializing a BFILE Locator Using C (OCI)
Example: Insert a Row Containing a BFILE by Initializing a BFILE Locator Using COBOL (Pro*COBOL)
Example: Insert a Row Containing a BFILE by Initializing a BFILE Locator Using C++ (Pro*C/C++)
Example: Insert a Row Containing a BFILE by Initializing a BFILE Locator Using Visual Basic (OO4O)
Example: Insert a Row Containing a BFILE by Initializing a BFILE Locator Using Java (JDBC)
Load External LOB (BFILE) Data into a Table
Scenario
Load a LOB with Data from a BFILE
Scenario
Example: Load a LOB with Data from a BFILE Using PL/SQL (DBMS_LOB Package)
Example: Load a LOB with Data from a BFILE Using C (OCI)
Example: Load a LOB with Data from a BFILE Using COBOL (Pro*COBOL)
Example: Load a LOB with Data from a BFILE Using C++ (Pro*C/C++)
Example: Load a LOB with Data from a BFILE Using Visual Basic (OO4O)
Example: Load a LOB with Data from a BFILE Using Java (JDBC)
Two Ways to Open a BFILE
Maximum Number of Open BFILEs
Open a BFILE with FILEOPEN
Scenario
Example: Open a BFILE with FILEOPEN Using PL/SQL
Example: Open a BFILE with FILEOPEN Using C (OCI)
Example: Open a BFILE with FILEOPEN Using Visual Basic (OO4O)
Example: Open a BFILE with FILEOPEN Using Java (JDBC)
Open a BFILE with OPEN
Scenario
Example: Open a BFILE with OPEN Using PL/SQL
Example: Open a BFILE with OPEN Using C (OCI)
Example: Open a BFILE with OPEN Using COBOL (Pro*COBOL)
Example: Open a BFILE with OPEN Using C++ (Pro*C/C++)
Example: Open a BFILE with OPEN Using Visual Basic (OO4O)
Example: Open a BFILE with OPEN Using Java (JDBC)
Two Ways to See If a BFILE is Open
Maximum Number of Open BFILEs
See If the BFILE is Open with FILEISOPEN
Scenario
Example: See If the BFILE is Open with FILEISOPEN Using PL/SQL (DBMS_LOB Package)
Example: See If the BFILE is Open with FILEISOPEN Using C (OCI)
Example: See If the BFILE is Open with FILEISOPEN Using Visual Basic (OO4O)
Example: See If the BFILE is Open with FILEISOPEN Using Java (JDBC)
See If the BFILE is Open Using ISOPEN
Scenario
Example: See If the BFILE is Open with ISOPEN Using PL/SQL (DBMS_LOB Package)
Example: See If the BFILE is Open with ISOPEN Using C (OCI)
Example: See If the BFILE is Open with ISOPEN Using COBOL (Pro*COBOL)
Example: See If the BFILE is Open with ISOPEN Using C++ (Pro*C/C++)
Example: See If the BFILE is Open with ISOPEN Using Visual Basic (OO4O)
Example: See If the BFILE is Open with ISOPEN Using Java (JDBC)
Display the BFILE Data
Scenario
Example: Display the BFILE Data Using PL/SQL
Example: Display the BFILE Data Using C (OCI)
Example: Display the BFILE Data Using COBOL (Pro*COBOL)
Example: Display the BFILE Data Using C++ (Pro*C/C++)
Example: Display the BFILE Data Using Visual Basic (OO4O)
Example: Display the BFILE Data Using Java (JDBC)
Read the Data from a BFILE
Scenario
Example: Read the Data from a BFILE Using PL/SQL (DBMS_LOB Package)
Example: Read the Data from a BFILE Using C (OCI)
Example: Read the Data from a BFILE Using COBOL (Pro*COBOL)
Example: Read the Data from a BFILE Using C++ (Pro*C/C++)
Example: Read the Data from a BFILE Using Visual Basic (OO4O)
Example: Read the Data from a BFILE Using Java (JDBC)
Read a Portion of the BFILE Data (substr)
Scenario
Example: Read a Portion of the BFILE Data (substr) Using PL/SQL (DBMS_LOB Package)
Example: Read a Portion of the BFILE Data (substr) Using COBOL (Pro*COBOL)
Example: Read a Portion of the BFILE Data (substr) Using C++ (Pro*C/C++)
Example: Read a Portion of the BFILE Data (substr) Using Visual Basic (OO4O)
Example: Read a Portion of the BFILE Data (substr) Using Java (JDBC)
Compare All or Parts of Two BFILES
Scenario
Example: Compare All or Parts of Two BFILES Using PL/SQL (DBMS_LOB Package)
Example: Compare All or Parts of Two BFILES Using COBOL (Pro*COBOL)
Example: Compare All or Parts of Two BFILES Using C++ (Pro*C/C++)
Example: Compare All or Parts of Two BFILES Using Visual Basic (OO4O)
Example: Compare All or Parts of Two BFILES Using Java (JDBC)
See If a Pattern Exists (instr) in the BFILE
Scenario
Example: See If a Pattern Exists (instr) in the BFILE Using PL/SQL (DBMS_LOB Package)
Example: See If a Pattern Exists (instr) in the BFILE Using COBOL (Pro*COBOL)
Example: See If a Pattern Exists (instr) in the BFILE Using C++ (Pro*C/C++)
Example: See If a Pattern Exists (instr) in the BFILE Using Visual Basic (OO4O)
Example: See If a Pattern Exists (instr) in the BFILE Using Java (JDBC)
See If the BFILE Exists
Scenario
Example: See If the BFILE Exists Using PL/SQL (DBMS_LOB Package)
Example: See If the BFILE Exists Using C (OCI)
Example: See If the BFILE Exists Using COBOL (Pro*COBOL)
Example: See If the BFILE Exists Using C++ (Pro*C/C++)
Example: See If the BFILE Exists Using Visual Basic (OO4O)
Example: See If the BFILE Exists Using Java (JDBC)
Get the Length of a BFILE
Scenario
Example: Get the Length of a BFILE Using PL/SQL (DBMS_LOB Package)
Example: Get the Length of a BFILE Using C (OCI)
Example: Get the Length of a BFILE Using COBOL (Pro*COBOL)
Example: Get the Length of a BFILE Using C++ (Pro*C/C++)
Example: Get the Length of a BFILE Using Visual Basic (OO4O)
Example: Get the Length of a BFILE Using Java (JDBC)
Copy a LOB Locator for a BFILE
Scenario
Example: Copy a LOB Locator for a BFILE Using PL/SQL
Example: Copy a LOB Locator for a BFILE Using C (OCI)
Example: Copy a LOB Locator for a BFILE Using COBOL (Pro*COBOL)
Example: Copy a LOB Locator for a BFILE Using C++ (Pro*C/C++)
Example: Copy a LOB Locator for a BFILE Using Visual Basic (OO4O)
Example: Copy a LOB Locator for a BFILE Using Java (JDBC)
See If a LOB Locator for a BFILE Is Initialized
Scenario
Example: See If a LOB Locator for a BFILE Is Initialized Using C (OCI)
Example: See If a LOB Locator for a BFILE Is Initialized Using C++ (Pro*C/C++)
See If One LOB Locator for a BFILE Is Equal to Another
Scenario
Example: See If One LOB Locator for a BFILE Is Equal to Another Using C (OCI)
Example: See If One LOB Locator for a BFILE Is Equal to Another Using C++ (Pro*C/C++)
Example: See If One LOB Locator for a BFILE Is Equal to Another Using Java (JDBC)
Get Directory Alias and Filename
Scenario
Example: Get Directory Alias and Filename Using PL/SQL
Example: Get Directory Alias and Filename Using C (OCI)
Example: Get Directory Alias and Filename Using COBOL (Pro*COBOL)
Example: Get Directory Alias and Filename Using C++ (Pro*C/C++)
Example: Get Directory Alias and Filename Using Visual Basic (OO4O)
Example: Get Directory Alias and Filename Using Java (JDBC)
Three Ways to Update a Row Containing a BFILE
UPDATE a BFILE Using BFILENAME()
BFILENAME() Function
Scenario
Example: Update a BFILE by means of BFILENAME() Using SQL
UPDATE a BFILE as SELECT
Scenario
Example: Update a BFILE as Select Using SQL
UPDATE a BFILE by Initializing a BFILE Locator
Scenario
Example: Update a BFILE by Initializing a BFILE Locator Using PL/SQL
Example: Update a BFILE by Initializing a BFILE Locator Using C (OCI)
Example: Update a BFILE by Initializing a BFILE Locator Using COBOL (Pro*COBOL)
Example: Update a BFILE by Initializing a BFILE Locator Using C++ (Pro*C/C++)
Example: Update a BFILE by Initializing a BFILE Locator Using Visual Basic (OO4O)
Example: Update a BFILE by Initializing a BFILE Locator Using Java (JDBC)
Two Ways to Close a BFILE
Close a BFILE with FILECLOSE
Scenario
Example: Close a BFile with FILECLOSE Using PL/SQL (DBMS_LOB Package)
Example: Close a BFile with FILECLOSE Using C (OCI)
Example: Close a BFile with FILECLOSE Using Visual Basic (OO4O)
Example: Close a BFile with FILECLOSE Using Java (JDBC)
Close a BFILE with CLOSE
Scenario
Example: Close a BFile with CLOSE Using PL/SQL (DBMS_LOB Package)
Example: Close a BFile with CLOSE Using C (OCI)
Example: Close a BFile with CLOSE Using COBOL (Pro*COBOL)
Example: Close a BFile with CLOSE Using C++ (Pro*C/C++)
Example: Close a BFile with CLOSE Using Visual Basic (OO4O)
Example: Close a BFile with CLOSE Using Java (JDBC)
Close All Open BFILEs
Scenario
Example: Close All Open BFiles Using PL/SQL (DBMS_LOB Package)
Example: Close All Open BFiles Using C (OCI)
Example: Close All Open BFiles Using COBOL (Pro*COBOL)
Example: Close All Open BFiles Using C++ (Pro*C/C++)
Example: Close All Open BFiles Using Visual Basic (OO4O)
Example: Close All Open BFiles Using Java (JDBC)
DELETE the Row of a Table Containing a BFILE
Scenario
Example: Delete a Row from a Table Using SQL

6 LOBs and Partitioned Tables

Using LOBs in Partitions
Creating and Partitioning a Table Containing LOB Data
Creating an Index on a Table Containing LOB Columns
Exchanging Partitions Containing LOB Data
Adding Partitions to Tables Containing LOB Data
Moving Partitions Containing LOBs
Splitting Partitions Containing LOBs
Merging Partitions Containing LOBs
Populating the Script CLOB and Photo BLOB

Index


Next
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.

Library
Product
Index