oracle知识点总结（Oracle knowledge point summary）.doc

oracle知识点总结（Oracle knowledge point summary） What is pl/SQL Pl/SQL (procedural language/SQL) is an extension of the Oracle on the standard SQL language, pl/SQL allows embedded SQL language, not only can define variables and constants, allows the use of conditional statement and circular statement, allows the use of exception handling all kinds of errors, which makes it become more powerful. Ii. The need for pl/SQL learning 1. Improve the performance of the application. 2. Modular design ideas. 3. Reduce network transmission. 4. Improve security. Iii. Preparation of specifications 1, comments, Single line comment -- SQL select * from emp where empno = 7788; -- obtain employee information Multiline comment / *... * / 2. Nomenclature for identifying symbols (1) when defining variables, use v_ as the prefix v_sal. (2) when defining constants, it is recommended to prefix c_rate with c_. (3) when defining the cursor, it is recommended to use _cursor as the suffix emp_cursor. (4) when an exception is defined, an e_ is recommended as a prefix e_error. Four, block Block (block) is the basic program unit of pl/SQL, and writing pl/SQL programs is essentially writing pl/SQL blocks. To complete a relatively simple application, you might simply write a pl/SQL fast. But if you want to implement complex functions, you may need to nest other pl/SQL fast in a pl/SQL block. 1. Block structure diagram The pl/SQL block consists of three parts: the definition part, the execution part, and the exception handling section. Declear: the definition begins with the declare, which is optional. Define constants, variables, cursor exceptions, complex data types. Begin: the execution part begins with begin, which is necessary. Exception: exception handling is started with exception, which is optional. A, contains the definition part and the execution part of the pl/SQL block declare V_ename varchar2 (5); -- defines string variables The begin Select ename int o v_ename from emp where empno = no; D