sql语句提高（国外英文资料）.doc

sql语句提高（国外英文资料） Pro * C study notes The 2011-07-21 09:52 reprint The man who eventually edited the dinosaur 1, the structure: Application header: | -- the external variable of C | - ORACLE Settings area (setting up ORACLE resource management) | RELEASE_CURSOR = YES; | -- the ORACLE variable description section (SQL variable definition) | EXEC SQL BEGIN DECLARE SECTION | (SQL variable definition) | EXEC SQL END DECLARE SECTION; | - SQL communication area | EXEC SQL INCLUDE SQLCA; | -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Application body: | -- the function body | -- an internal explanation | | -- C local variable | | - the ORACLE internal variable specification section | | EXEC SQL BEGIN DECLARE SECTION |, | (SQL variable definition) | | EXEC SQL END DECLARE SECTION; | | -- the SQL communication area | -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- | -- the execution part | - C statement | - SQL or PL/SQL block | EXEC SQL CONNECT: user name | IDENTIFIED BY: password | SQL statement and cursor usage; -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- About variable declarations and usage -- declaration of variable case distinction; The host variable must be clearly defined; If declared outside all functions, the variable is a global variable; If it is declared in the function, it is a local variable for the function; The host variable is typically declared as a global variable; The call variable in the SQL statement is the colon before the variable :; A variable cannot be a reserved word in SQL; The pointer variable can also be invoked in SQL, with a colon in front, instead of a * number, plus * in C. To specify the maximum length of a string for the variable declaration of a pseudo-type (Varchar) : Varchar book_name [50]; - defined in the database tables for VARCHAR2, VARCHAR, CHAR fields, in the PROC can be declared as CHAR, but they length should be defined in table 1, the length of the CHAR variable b