4/37

List of Tables

• 1-1 Large Object Data Types
• 4-1 Parameters of CREATE TABLE Statement
• 4-2 Parameters of ALTER TABLE Statement
• 4-3 Some DBMS_LOB Constants
• 4-4 DBMS_LOB Methods
• 9-1 Methods of the DBMS_DBFS_HS Pl/SQL Packages
• 11-1 LOBs Vs. LONG RAW
• 11-2 Recommended PCTVERSION Settings
• 11-3 When to Use CACHE, NOCACHE, and CACHE READS
• 11-4 Data Size and CHUNK Size
• 13-1 Programmatic Environments That Support LOBs
• 13-2 Comparing the LOB Interfaces, 1 of 2
• 13-3 Comparing the LOB Interfaces, 2 of 2
• 13-4 PL/SQL: DBMS_LOB Procedures to Modify LOB Values
• 13-5 PL/SQL: DBMS_LOB Procedures to Read or Examine Internal and External LOB values
• 13-6 PL/SQL: DBMS_LOB Procedures to Operate on Temporary LOBs
• 13-7 PL/SQL: DBMS_LOB Read-Only Procedures for BFILEs
• 13-8 PL/SQL: DBMS_LOB Procedures to Open and Close Internal and External LOBs
• 13-9 OCI Functions to Modify Persistent LOB (BLOB, CLOB, and NCLOB) Values
• 13-10 OCI Functions to Read or Examine persistent LOB and external LOB (BFILE) Values
• 13-11 OCI Functions for Temporary LOBs
• 13-12 OCI Read-Only Functions for BFILES
• 13-13 OCI LOB-Locator Functions
• 13-14 OCI LOB-Buffering Functions
• 13-15 OCI Functions to Open and Close Internal and External LOBs
• 13-16 OCCI Clob and Blob Methods to Modify Persistent LOB (BLOB, CLOB, and NCLOB) Values
• 13-17 OCCI Blob/Clob/Bfile Methods to Read or Examine persistent LOB and BFILE Values
• 13-18 OCCI Read-Only Methods for BFILES
• 13-19 Other OCCI LOB Methods
• 13-20 OCCI Methods to Open and Close Internal and External LOBs
• 13-21 Pro*C/C++: Embedded SQL Statements to Modify Persistent LOB Values
• 13-22 Pro*C/C++: Embedded SQL Statements for Introspection of LOBs
• 13-23 Pro*C/C++: Embedded SQL Statements for Temporary LOBs
• 13-24 Pro*C/C++: Embedded SQL Statements for BFILES
• 13-25 Pro*C/C++ Embedded SQL Statements for LOB Locators
• 13-26 Pro*C/C++ Embedded SQL Statements for LOB Buffering
• 13-27 Pro*C/C++ Embedded SQL Statements to Open and Close Persistent LOBs and External LOBs (BFILEs)
• 13-28 Pro*COBOL Embedded SQL Statements to Modify LOB Values
• 13-29 Pro*COBOL Embedded SQL Statements for Introspection of LOBs
• 13-30 Pro*COBOL Embedded SQL Statements for Temporary LOBs
• 13-31 Pro*COBOL Embedded SQL Statements for BFILES
• 13-32 Pro*COBOL Embedded SQL Statements for LOB Locator Statements
• 13-33 Pro*COBOL Embedded SQL Statements for LOB Buffering
• 13-34 Pro*COBOL Embedded SQL Statements for Opening and Closing Persistent LOBs and BFILEs
• 13-35 OO4O Methods to Modify BLOB, CLOB, and NCLOB Values
• 13-36 OO4O Methods to Read or Examine Internal and External LOB Values
• 13-37 OO4O Methods to Open and Close External LOBs (BFILEs)
• 13-38 OO4O Methods for Persistent LOB Buffering
• 13-39 OO4O Properties for Operating on LOBs
• 13-40 OO4O Read-Only Methods for External LOBs (BFILEs)
• 13-41 OO4O Properties for Operating on External LOBs (BFILEs)
• 13-42 BLOB Method Equivalents
• 13-43 CLOB Method Equivalents
• 13-44 JDBC oracle.sql.BLOB Methods To Modify BLOB Values
• 13-45 JDBC oracle.sql.BLOB Methods to Read or Examine BLOB Values
• 13-46 JDBC oracle.sql.BLOB Methods and Properties for BLOB Buffering
• 13-47 JDBC oracle.sql.CLOB Methods to Modify CLOB Values
• 13-48 JDBC oracle.sql.CLOB Methods to Read or Examine CLOB Values
• 13-49 JDBC oracle.sql.CLOB Methods and Properties for CLOB Buffering
• 13-50 JDBC oracle.sql.BFILE Methods to Read or Examine External LOB (BFILE) Values
• 13-51 JDBC oracle.sql.BFILE Methods and Properties for BFILE Buffering
• 13-52 JDBC: Temporary BLOB APIs
• 13-53 JDBC: Temporary CLOB APIs
• 13-54 JDBC: Opening and Closing BLOBs
• 13-55 JDBC: Opening and Closing CLOBs
• 13-56 JDBC API Extensions for Opening and Closing BFILEs
• 13-57 JDBC: Truncating BLOBs
• 13-58 JDBC: Truncating CLOBs
• 13-59 JDBC: BLOB Streaming APIs
• 13-60 JDBC: CLOB Streaming APIs
• 13-61 JDBC: BFILE Streaming APIs
• 16-1 SQL VARCHAR2 Functions and Operators on LOBs
• 16-2 Unsupported Usage of LOBs in SQL
• 20-1 Corresponding LONG and LOB Datatypes in SQL and PL/SQL
• 20-2 Corresponding LONG and LOB Datatypes in OCI
• 21-1 Environments Supported for BFILE APIs
• 22-1 Environments Supported for LOB APIs
• 22-2 Maximum LOB Size for Load from File Operations
• 22-3 Maximum LOB Size for Amount Parameter
• A-1 PL/SQL Demonstration Examples
• A-2 OCI Demonstration Examples
• A-3 COM OO4O Demonstration Examples
• A-4 Java Demonstration Examples