List of Examples

1-1 Creating and Specifying Access to a Table
1-2 Creating an Object Table
1-3 Inserting Data through Input Bind Variables
1-4 Inserting Objects into the Oracle Database
1-5 Using the Simple SELECT Statement
1-6 Using the SELECT Statement with Input Variables
1-7 Using PL/SQL to Obtain an Output Variable
1-8 Using PL/SQL to Partial Records into Placeholders
1-9 Using SQL to Extract Partial Records
2-1 How to Determine the Major Client Version and set Performance Features
2-2 Installing Instant Client Light (English) through Oracle Universal Installer
3-1 Usage Scenario for a StatelessConnectionPool
3-2 How to Create and Use a Homogeneous Stateless Connection Pool
3-3 How to Create and Use a Heterogeneous Stateless Connection Pool
3-4 How to Bind Data in a Streaming Mode
3-5 How to Fetch Data in a Streaming Mode Using PL/SQL
3-6 How to Read and Write with Multiple Streams
3-7 How to Fetch Data in Streaming Mode Using ResultSet
3-8 Statement Caching without Connection Pooling
3-9 Statement Caching with Connection Pooling
4-1 Creating Standalone Objects
4-2 Creating Embedded Objects
4-3 Creating a Persistent Object
4-4 Creating a Transient Object
4-5 OTT Support Inheritance
4-6 Listing of demo2.sql for a Sample OCCI Application
4-7 Listing of demo2.typ for a Sample OCCI Application
4-8 Listing of OTT Command that Generates Files for a Sample OCCI Application
4-9 Listing of mappings.h for a Sample OCCI Application
4-10 Listing of mappings.cpp for a Sample OCCI Application
4-11 Listing of demo2.h for a Sample OCCI Application
4-12 Listing of demo2.cpp for a Sample OCCI Application
4-13 Listing of myDemo.h for a Sample OCCI Application
4-14 Listing for myDemo.cpp for a Sample OCCI Application
4-15 Listing of main.cpp for a Sample OCCI Application
5-1 Definition of the BDOUBLE Datatype
5-2 Definition of the BFLOAT Datatype
6-1 How to Obtain Metadata About Attributes of a Simple Database Table
6-2 How to Obtain Metadata from a Column Containing User-Defined Types
6-3 How to Obtain Object Oetadata from a Reference
6-4 How to Obtain Metadata About a Select List from a ResultSet Object
7-1 How to Use the OTT Utility
7-2 Object Creation Statements of the OTT Utility
7-3 How to Invoke the OTT Utility to Generate C++ Classes
7-4 How to use the SCHEMA_NAMES Parameter in OTT Utility
7-5 How to Define a Schema for Unicode Support in OTT
7-6 How to Use UNICODE=ALL Parameter in OTT
7-7 How to Use UNICODE=ONLYCHAR Parameter in OTT
7-8 How to Create a User Defined INTYPE File Using the OTT Utility
7-9 Listing of ott95a.h
7-10 Listing of ott95b.h
7-11 How to Represent Object Attributes Using the OTT Utility
7-12 How to Map Object Datatypes Using the OTT Utility
7-13 OUTTYPE File Generated by the OTT Utility
7-14 How to Generate C++ Classes Using the OTT Utility
7-15 How to Extend C++ Classes Using the OTT Utility
7-16 How to Add User Code to a Header File Using OTT Utility
7-17 How to Add User Code to the Source File Using the OTT Utility
8-1 How to Use Globalization and Unicode Support
8-2 Using wstring Datatype
8-3 Binding UTF8 Data Using the string Datatype
8-4 Binding UTF16 Data Using the UString Datatype
8-5 Using CLOB and NCLOB Datatypes
9-1 Creating an Agent
9-2 Setting the Agent on the Consumer
9-3 Creating an AnyData Message with a String Payload
9-4 Determining the Type of the Payload in an AnyData Message
9-5 Creating an User-defined Payload
9-6 Specifying the Correlation identifier
9-7 Specifying the Sender identifier
9-8 Specifying the Delay and Expiration times of the message
9-9 Specifying message recipients
9-10 Specifying the Priority of a Message
9-11 Creating a Producer, Setting Visibility, and Enqueuing the Message
9-12 Creating a Consumer, Naming the Consumer, and Receiving a Message
9-13 Receiving a Message
9-14 Specifying dequeuing options
9-15 Listening for messages
9-16 How to Register for Notifications; Direct Registration
9-17 How to Use Open Registration with LDAP
10-1 How to Use Transaction Managers with XA
11-1 How to use Array Fetch with a ResultSet
11-2 How to Modify Rows Iteratively and Handle Errors
12-1 Converting From an SQL Pre-Defined Type To AnyData Type
12-2 Creating an SQL Pre-Defined Type From AnyData Type
12-3 Converting From a User-Defined Type To AnyData Type
12-4 Converting From a User-Defined Type To AnyData Type
12-5 How to Get a Date from Database and Use it in Standalone Calculations
12-6 How to Create, Assign Values, and Use an Empty IntervalDS Object through Direct Assignment
12-7 How to Create, Assign Values, and Use an Empty IntervalDS Object through fromText() and toText() Methods
12-8 How to Create, Assign Values, and Use an Empty IntervalYM Object through Direct Assignment
12-9 How to Create, Assign Values, and Use an IntervalYM Object through ResultSet and toText() method
12-10 How to Retrieve and Use a Number Obect
12-11 Using Default Timestamp Constructor
12-12 Using fromText() method to Initialize a NULL Timestamp Instance
12-13 Comparing Timestamps Stored in the Database