Temario Pro C

Part I Introduction and Concepts
1 Introduction
This chapter contains the following topics:
* What is an Oracle Precompiler?
* Why Use the Oracle Pro*C/C++ Precompiler
* Why Use SQL
* Why Use PL/SQL
* Pro*C/C++ Precompiler Benefits
* Frequently Asked Questions

* What is an Oracle Precompiler?
* Why Use the Oracle Pro*C/C++ Precompiler
* Why Use SQL
*Why Use PL/SQL
* Pro*C/C++ Precompiler Benefits
* Directory Structure
* Known Problems, Restrictions, and Workarounds
* Library Files
* Frequently Asked Questions
* What is a VARCHAR?
* Does Pro*C/C++ Generate Calls to the Oracle Call Interface?
* Why Not Code Using SQLLIB Calls and Not Use Pro*C/C++?
* Can I Call A PL/SQL Stored Procedure From aPro*C/C++ Program?
* Can I Write C++ Code, and Precompile It Using Pro*C/C++?
* Can I Use Bind Variables Anywhere in a SQL Statement?
* I Am Confused By Character Handling in Pro*C/C++.
* Is There Anything Special About Character Pointers?
* Why Does SPOOL Not Work in Pro*C/C++?
* Where Can I Find The On-line Versions of the Example Programs?
* HowCan I Compile and Link My Application?
* Does Pro*C/C++ Now Support Using Structures As Host Variables?
* Is It Possible to Have Recursive Functions In Pro*C/C++ If I Use Embedded SQL In the Function?
* Can I Use Any Release of Pro*C/C++ with Any Version of the Oracle Server?
* When My Application Runs Under Oracle9i, I Keep Getting an Ora-1405 Error (Fetched ColumnValue Is NULL).
* Are All SQLLIB Functions Private?
* How Does Oracle9i Support The New Object Types?
* Compatibility, Upgrading, and Migration
2 Precompiler Concepts
section lays the conceptual foundation on which later chapters build. This section contains these topics:
* Embedded SQL Statements
* Embedded SQL Syntax
* Static Versus Dynamic SQL Statements
*Embedded PL/SQL Blocks
* Host and Indicator Variables
* Oracle Datatypes
* Arrays
* Datatype Equivalencing
* Private SQL Areas, Cursors, and Active Sets
* Transactions
* Errors and Warnings
* SQL99 Syntax Support

* Key Concepts of Embedded SQL Programming
* Embedded SQL Statements
* Executable Statements and Directives
* Embedded SQLSyntax
* Static Versus Dynamic SQL Statements
* Embedded PL/SQL Blocks
* Host and Indicator Variables
* Oracle Datatypes
* Arrays
* Datatype Equivalencing
* Private SQL Areas, Cursors, and Active Sets
* Transactions
* Errors and Warnings
* SQL99 Syntax Support
* Steps in Developing an Embedded SQL Application
* Guidelinesfor Programming
* Comments
* Constants
* Declare Section
* Delimiters
* File Length
* Function Prototyping
* ANSI_C
* KR_C
* CPP
* Hint Length
* Host Variable Names
* Line Continuation
* Line Length
* MAXLITERAL Default Value
* Operators
* Statement Terminator
*Conditional Precompilation
* Symbol Definition
* Example SELECT Statement
* Precompile Separately
* Guidelines
* Referencing Cursors
* Specifying MAXOPENCURSORS
* Use a Single SQLCA
* Compile and Link
* Example Tables
* Example Data
* Example Program: A Simple Query
* Example Program: A Simple Query using SQL99 Syntax
3Database Concepts
This chapter contains the following topics:
* Connect to the Database
* Advanced Connection Options
* Definitions of Transactions Terms
* How Transactions Guard Your Database
* How to Begin and End Transactions
* Using the COMMIT Statement
* Using the SAVEPOINT Statement
* The ROLLBACK Statement
* The RELEASE Option
* The SET TRANSACTION...