 |
|
| |
About the course The ability to gain the performance advantages of C, together with its flexibility, and the ability to access database records is a powerful toolset for the developer. PRO*C is the embedded language for coding database calls in the C programming language and brings these hthree objectives together. You will learn sufficient Oracle SQL to understand how to form ESQL calls in C. Should you require full training in the Oracle SQL command set, may we recommend our Oracle SQL training course to you. The training is rich in hands-on and several workshops are included, based on common operational and business scenarios. Prerequisites Delegates should be familiar with the C programming language. Familiarity with Oracle is an added advantage. Duration 3 days |
| 1.
Overview of Pro*C The Pro*C programming interface Types of Pro*C statements A quick tour of the Pro*C environment |
5.
Modifying the Database with ESQL
Data manipulation using insert, update, and delete Transactions and locking Data definition statements |
9.
Dynamic SQL Methods 1,2,&3
Uses of dynamic SQL Overview of the 4 dynamic methods Methods 1, 2, and 3 |
| 2. Integrating
Pro*C with GUI Environments
Setting up Microsoft Visual C++ to support Pro*C Creating and manage Pro*C projects in Microsoft Visual C++ Using Pro*C in other GUI environments with ProcUI |
6. Multi-Row
Queries using Cursors
Overview of multi-row queries. Using cursors with multi-row queries. Declare, fetch, open, and close statements |
10. Dynamic
SQL Method 4 Method 4 overview SQL descriptor area Non-query example using method 4 Query example using method 4 |
| 3. Single-Row
Queries using ESQL
Single-row queries The declare section A comparison of Oracle and C data types String handling within Pro*C |
7. ESQL
using Host Arrays
Using host arrays. Selecting into host arrays. Modifying data with host arrays. Indicator arrays. |
11. Final
Project Database library |
| 4. Error
Handling SQL Communications Area The Whenever Statement Indicator Variables |
8. ESQL
with PL/SQL Using PL/SQL with Pro*C Using C host variables with PL/SQL Creating and calling PL/SQL procedures with Pro*C Indicator variables within PL/SQL |
