List of Examples
- 1-1 Creating a Table
- 1-2 Specifying Access to a Table
- 1-3 Creating an Object Table
- 1-4 Inserting Data Through Input Bind Variables
- 1-5 Inserting Objects into the Oracle Database
- 1-6 Using the Simple SELECT Statement
- 1-7 Using the SELECT Statement with Input Variables
- 1-8 Using PL/SQL to Obtain an Output Variable
- 1-9 Using PL/SQL to Insert Partial Records into Placeholders
- 1-10 Using SQL to Extract Partial Records
- 2-1 How to Determine the Major Client Version and Set Performance Features
- 2-2 How to Regenerate the Data Shared Library Files
- 2-3 How to set the ORA_TZFILE Environment Variable
- 2-4 Installing Instant Client Light (English) through Oracle Universal Installer
- 3-1 How to Create an OCCI Environment
- 3-2 How to Terminate an OCCI Environment
- 3-3 How to Use Environment Scope with Blob Objects
- 3-4 How to Create an Environment and then a Connection to the Database
- 3-5 How to Terminate a Connection to the Database and the Environment
- 3-6 The createConnectionPool() Method
- 3-7 How to Create a Connection Pool
- 3-8 The createProxyConnection() Method
- 3-9 How to Use a StatelessConnectionPool
- 3-10 How to Create and Use a Homogeneous Stateless Connection Pool
- 3-11 How to Create and Use a Heterogeneous Stateless Connection Pool
- 3-12 How to Administer the Database Resident Connection Pools
- 3-13 How to Get a Connection from a Database Resident Connection Pool
- 3-14 Using Client-Side Pool and Server-Side Pool
- 3-15 How to Create a Statement
- 3-16 How to Create a Database Table Using the executeUpdate() Method
- 3-17 How to Add Records Using the executeUpdate() Method
- 3-18 How to Specify a SQL Statement Using the setSQL() Method
- 3-19 How to Reset a SQL Statement Using the setSQL() Method
- 3-20 How to Terminate a Statement Using the terminateStatement() Method
- 3-21 How to Use setxxx() Methods to Set Individual Column Values
- 3-22 How to Specify the IN Parameters of a PL/SQL Stored Procedure
- 3-23 How to Specify OUT Parameters of a PL/SQL Stored Procedure
- 3-24 How to Bind Data in a Streaming Mode
- 3-25 How to Fetch Data in a Streaming Mode Using PL/SQL
- 3-26 How to Read and Write with Multiple Streams
- 3-27 How to Execute an Iterative Operation
- 3-28 How to Fetch Data in Streaming Mode Using ResultSet
- 3-29 SELECT with getUb8RowCount(); simple
- 3-30 SELECT with getUb8RowCount(); with prefetch
- 3-31 SELECT with getUb8RowCount(); array fetch with prefetch
- 3-32 INSERT with getUb8RowCount(); simple
- 3-33 INSERT with getUb8RowCount(); with iterations
- 3-34 UPDATE with getUb8RowCount()
- 3-35 Statement Caching without Connection Pooling
- 3-36 Statement Caching with Connection Pooling
- 4-1 Creating Standalone Objects
- 4-2 Creating Embedded Objects
- 4-3 Two Methods for Operator new() in the Object Type Translator Utility
- 4-4 How to Dynamically Create a Transient Object
- 4-5 How to Create a Transient Object as a Local Variable
- 4-6 How to Create a Persistent Object
- 4-7 How to Create a Transient Object
- 4-8 How to Declare a Custom Type in the Database
- 4-9 How to Create a VARRAY Collection
- 4-10 OTT Support Inheritance
- 4-11 Listing of demo2.sql for a Sample OCCI Application
- 4-12 Listing of demo2.typ for a Sample OCCI Application
- 4-13 Listing of OTT Command that Generates Files for a Sample OCCI Application
- 4-14 Listing of mappings.h for a Sample OCCI Application
- 4-15 Listing of mappings.cpp for a Sample OCCI Application
- 4-16 Listing of demo2.h for a Sample OCCI Application
- 4-17 Listing of demo2.cpp for a Sample OCCI Application
- 4-18 Listing of myDemo.h for a Sample OCCI Application
- 4-19 Listing for myDemo.cpp for a Sample OCCI Application
- 4-20 Listing of main.cpp for a Sample OCCI Application
- 5-1 Definition of the BDOUBLE Data Type
- 5-2 Definition of the BFLOAT Data Type
- 6-1 How to use Identity Column Metadata
- 6-2 How to Obtain Metadata About Attributes of a Simple Database Table
- 6-3 How to Obtain Metadata from a Column Containing User-Defined Types
- 6-4 How to Obtain Object Metadata from a Reference
- 6-5 How to Obtain Metadata About a Select List from a ResultSet Object
- 7-1 How to Read Non-Streamed BLOBs
- 7-2 How to Read Non-Streamed BFILESs
- 7-3 How to Read Streamed BLOBs
- 7-4 How to Write Non-Streamed BLOBs
- 7-5 How to Write Streamed BLOBs
- 7-6 Updating a CLOB Value
- 7-7 Updating a BFILE Value
- 7-8 How to Use a Persistent Object with a BLOB Attribute
- 7-9 How to Use a Persistent Object with a BFILE Attribute
- 8-1 How to Use the OTT Utility
- 8-2 Object Creation Statements of the OTT Utility
- 8-3 How to Invoke the OTT Utility to Generate C++ Classes
- 8-4 How to use the SCHEMA_NAMES Parameter in OTT Utility
- 8-5 How to Define a Schema for Unicode Support in OTT
- 8-6 How to Use UNICODE=ALL Parameter in OTT
- 8-7 How to Use UNICODE=ONLYCHAR Parameter in OTT
- 8-8 How to Create a User Defined INTYPE File Using the OTT Utility
- 8-9 Listing of ott95a.h
- 8-10 Listing of ott95b.h
- 8-11 How to Represent Object Attributes Using the OTT Utility
- 8-12 How to Map Object Data Types Using the OTT Utility
- 8-13 OUTTYPE File Generated by the OTT Utility
- 8-14 How to Generate C++ Classes Using the OTT Utility
- 8-15 How to Extend C++ Classes Using the OTT Utility
- 9-1 How to Use Globalization and Unicode Support
- 9-2 Using wstring Data Type
- 9-3 Binding UTF8 Data Using the string Data Type
- 9-4 Binding UTF16 Data Using the UString Data Type
- 9-5 Using CLOB and NCLOB Data Types
- 10-1 Creating an Agent
- 10-2 Setting the Agent on the Consumer
- 10-3 Creating an AnyData Message with a String Payload
- 10-4 Determining the Type of the Payload in an AnyData Message
- 10-5 Creating an User-defined Payload
- 10-6 Specifying the Correlation identifier
- 10-7 Specifying the Sender identifier
- 10-8 Specifying the Delay and Expiration times of the message
- 10-9 Specifying message recipients
- 10-10 Specifying the Priority of a Message
- 10-11 Creating a Producer, Setting Visibility, and Enqueuing the Message
- 10-12 Creating a Consumer, Naming the Consumer, and Receiving a Message
- 10-13 Receiving a Message
- 10-14 Specifying dequeuing options
- 10-15 Listening for messages
- 10-16 How to Register for Notifications; Direct Registration
- 10-17 How to Use Open Registration with LDAP
- 11-1 How to Use Transaction Managers with XA
- 12-1 How to Enable TAF for Connection Pooling
- 12-2 How to Insert Records Using the addIteration() method
- 12-3 How to Insert Records Using the executeArrayUpdate() Method
- 12-4 How to use Array Fetch with a ResultSet
- 12-5 How to Modify Rows Iteratively and Handle Errors
- 12-6 How to Use ADRCI for OCCI Application Incidents
- 12-7 How to Use ADRCI for Instant Client
- 12-8 How to Enable and Use the Client Result Cache
- 13-1 Converting From an SQL Pre-Defined Type To AnyData Type
- 13-2 Creating an SQL Pre-Defined Type From AnyData Type
- 13-3 Converting From a User-Defined Type To AnyData Type
- 13-4 Converting From a User-Defined Type To AnyData Type
- 13-5 How to Get a Date from Database and Use it in Standalone Calculations
- 13-6 How to Use an Empty IntervalDS Object through Direct Assignment
- 13-7 How to Use an Empty IntervalDS Object Through *Text() Methods
- 13-8 How to Use an Empty IntervalYM Object Through Direct Assignment
- 13-9 How to Use an IntervalYM Object Through ResultSet and toText() Method
- 13-10 How to Retrieve and Use a Number Object
- 13-11 Using Default Timestamp Constructor
- 13-12 Using fromText() method to Initialize a NULL Timestamp Instance
- 13-13 Comparing Timestamps Stored in the Database