ORACLE ProC文库（ORACLE ProC library）.doc

ORACLE ProC文库（ORACLE ProC library） ORACLE ProC library. TXT ORACLE training course: use of pro * c (1) I. overview of Pro * C procedures 1. What is the Pro * C program In ORACLE database management and systems, there are three ways to access a database: O SQL * Plus, which has SQL commands to access the database with interactive applications; O use applications developed in the fourth generation language application to access the database. These tools have SQL * Froms, QL * Reportwriter, SQL Menu, and so on. O is accessed using SQL language or ORACLE library function calls embedded in the third generation of languages. Pro * C is one of the third kind of development tools, it is the procedural and non-procedural language C language SQL is the most perfectly together, has a complete process capability, and can accomplish any substandard goods task database, the user can be programmed to complete various types of reports. In Pro * C program can be embedded SQL language, use the SQL language can complete dynamically establish, modify, and delete the tables in the database, can also query, insert, modify, and delete rows in a database table, you can also implement commit and rollback transaction. In the Pro * C program, you can also embed PL/SQL blocks to improve the performance of your application, especially in a network environment, which reduces the total overhead of network transmission and processing. 2. Procedure structure of Pro * C In general, Pro * C programs are actually C programs embedded with SQL statements or PL/SQL blocks, so its composition is very similar to C programs. But because it has SQL statements or PL/SQL blocks embedded, it also contains a different component. In order to give you a sense of the Pro * C, the difference between the two is shown in the figure below. (click to view larger image) The structure of the two Pro * C program Each Pro * C program consists of two parts: the first of the application; Application body. The application head