In order to expand and collapse the table of contents, you must enable JavaScript in the browser.
(Collapse Contents)
Title Page
Preface
Chapter 1 Overview of the Application Development Function
1.1 Support for National Characters
1.1.1 Literal
1.1.2 Data Type
1.1.3 Functions and Operator
1.2 Compatibility with Oracle Database
1.3 Application Connection Switch Feature
1.3.1 Integration with Database Multiplexing
1.4 Notes on Application Compatibility
1.4.1 Checking Execution Results
1.4.2 Referencing System Catalogs
1.4.3 Using Functions
Chapter 2 JDBC Driver
2.1 Development Environment
2.1.1 Combining with JDK or JRE
2.2 Setup
2.2.1 Environment Settings
2.2.2 Message Language and Encoding System Used by Applications Settings
2.2.3 Settings for Encrypting Communication Data
2.3 Connecting to the Database
2.3.1 Using the DriverManager Class
2.3.2 Using the PGConnectionPoolDataSource Class
2.3.3 Using the PGXADataSource Class
2.4 Application Development
2.4.1 Relationship between the Application Data Types and Database Data Types
2.4.2 Statement Caching Feature
2.4.3 Creating Applications while in Database Multiplexing Mode
2.4.3.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 3 ODBC Driver
3.1 Development Environment
3.2 Setup
3.2.1 Registering ODBC Drivers
3.2.2 Registering ODBC Data Sources
3.2.3 Message Language and Encoding System Used by Applications Settings
3.3 Connecting to the Database
3.4 Application Development
3.4.1 Compiling Applications
3.4.2 Creating Applications While in Database Multiplexing Mode
3.4.2.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 4 C Library (libpq)
4.1 Development Environment
4.2 Setup
4.2.1 Environment Settings
4.2.2 Message Language and Encoding System Used by Applications Settings
4.2.3 Settings for Encrypting Communication Data
4.3 Connecting with the Database
4.4 Application Development
4.4.1 Compiling Applications
4.4.2 Creating Applications while in Database Multiplexing Mode
4.4.2.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
Chapter 5 Embedded SQL in C
5.1 Development Environment
5.2 Setup
5.2.1 Environment Settings
5.2.2 Message Language and Encoding System Used by Applications Settings
5.2.3 Settings for Encrypting Communication Data
5.3 Connecting with the Database
5.4 Application Development
5.4.1 Support for National Character Data Types
5.4.2 Compiling Applications
5.4.3 Bulk INSERT
5.4.4 Creating Applications while in Database Multiplexing Mode
5.4.4.1 Errors when an Application Connection Switch Occurs and Corresponding Actions
5.4.5 Notes
Chapter 6 SQL References
6.1 Expanded Trigger Definition Feature
6.1.1 CREATE TRIGGER
Chapter 7 Compatibility with Oracle Databases
7.1 Overview
7.2 Precautions when Using the Features Compatible with Oracle Databases
7.2.1 Notes on SUBSTR
7.2.2 Notes when Integrating with the Interface for Application Development
7.3 Queries
7.3.1 Outer Join Operator (+)
7.3.2 DUAL Table
7.4 SQL Function Reference
7.4.1 DECODE
7.4.2 SUBSTR
7.4.3 NVL
7.5 Package Reference
7.5.1 DBMS_SQL
7.5.1.1 Description
7.5.1.2 Example
Chapter 8 Application Connection Switch Feature
8.1 Connection Information for the Application Connection Switch Feature
8.2 Using the Application Connection Switch Feature
8.2.1 Using the JDBC Driver
8.2.2 Using the ODBC Driver
8.2.3 Using a Connection Service File
8.2.4 Using the C Library (libpq)
8.2.5 Using Embedded SQL
8.2.6 Using the psql Command
Chapter 9 Performance Tuning
9.1 Enhanced Query Plan Stability
9.1.1 Optimizer Hints
9.1.2 Locked Statistics
Chapter 10 Scan Using a Vertical Clustered Index (VCI)
10.1 Operating Conditions
10.2 Usage
10.2.1 Designing
10.2.2 Checking
10.2.3 Evaluating
10.3 Usage Notes
Appendix A Precautions when Developing Applications
A.1 Precautions when Using Functions and Operators
A.1.1 General rules of Functions and Operators
A.1.2 Errors when Developing Applications that Use Functions and/or Operators
A.2 Notes when Using Temporary Tables
A.3 Implicit Data Type Conversions
A.3.1 Function Argument
A.3.2 Operators
A.3.3 Storing Values
A.4 Notes on Using Index
A.4.1 SP-GiST Index
A.5 Notes on Using Multibyte Characters in Definition Names
Appendix B Conversion Procedures Required due to Differences from Oracle Database
B.1 Outer Join Operator (Perform Outer Join)
B.1.1 Comparing with the ^= Comparison Operator
B.2 DECODE (Compare Values and Return Corresponding Results)
B.2.1 Comparing Numeric Data of Character String Types and Numeric Characters
B.2.2 Obtaining Comparison Result from more than 50 Conditional Expressions
B.2.3 Obtaining Comparison Result from Values with Different Data Types
B.3 SUBSTR (Extract a String of the Specified Length from Another String)
B.3.1 Specifying a Value Expression with a Data Type Different from the One that can be Specified for Function Arguments
B.3.2 Extracting a String with the Specified Format from a Datetime Type Value
B.3.3 Concatenating a String Value with a NULL value
B.4 NVL (Replace NULL)
B.4.1 Obtaining Result from Arguments with Different Data Types
B.4.2 Operating on Datetime/Numeric, Including Adding Number of Days to a Particular Day
B.4.3 Calculating INTERVAL Values, Including Adding Periods to a Date
B.5 DBMS_OUTPUT (Output Messages)
B.5.1 Outputting Messages Such As Process Progress Status
B.5.2 Receiving a Return Value from a Procedure (PL/SQL) Block (For GET_LINES)
B.5.3 Receiving a Return Value from a Procedure (PL/SQL) Block (For GET_LINE)
B.6 UTL_FILE (Perform File Operation)
B.6.1 Registering a Directory to Load and Write Text Files
B.6.2 Checking File Information
B.6.3 Copying Files
B.6.4 Moving/Renaming Files
B.7 DBMS_SQL (Execute Dynamic SQL)
B.7.1 Searching Using a Cursor
Appendix C Tables Used by the Features Compatible with Oracle Databases
C.1 UTL_FILE.UTL_FILE_DIR
Appendix D Quantitative Limits
Appendix E Reference
E.1 JDBC Driver
E.2 ODBC Driver
E.2.1 List of Supported APIs
E.3 C Library (libpq)
E.4 Embedded SQL in C
Top