Oracle9i笔记1(11)

Operators in PL/SQL Logical

Arithmetic 算法 Concatenation 連結

Parentheses to control order of operations Exponential operator (* *)

Operators in PL/SQL

Increment the counter for a loop: V_count := v_count+1;

Set the values of a Boolean flag. V_equal := (v_n1=v_n2);

Validate if an employee number contains a value. V_valid := (v_empno IS NOT NULL);

Programming Guidelines

Make code maintenance easier by: Documenting code with comments

Developing a case convention for the code. 用代碼慣例

Developing naming conventions for identifiers and other objects. Identifiers 命名慣例。 Enhancing readability by identing

程序格式習慣：

SQL statements, PL/SQL keywords, Datatypes 3類都用大寫字母 Identifiers,parameters ; database tables and columns 2類用小寫字母

Chapter 3

Interacting with the oracle sever

After completing this lesson, you should be able to do the following: Write a successful select statement in PL/SQL Write DML statements in PL/SQL Control transactions in PL/SQL

Determine the outcome of SQL Data Manipulation Language(DML) statements

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新人文社科Oracle9i笔记1(11)全文阅读和word下载服务。