PL SQL « Oracle PL / SQL





PL SQL /

APPEND 1Arithmetic Operators 1Begin End Block 15Between and 4
Boolean Expression 4Break 2CARDINALITY 3Case 10
Char to Number 1Char Varchar Compare 5Column Type Variable 2Comments 3
Compile Error 10Concatenation Operator 1Conditional_compilation 1Console Prompt Read 4
Constant Number 5Data Insert 14Data Type Convert 10Data Type Define 2
Date Calculation 2DATE Compare 2Date Convert 2DBMS_OUTPUT 4
Decode 6Default Value 3Define 3Delete Data 8
Dump 1Errors Table 1Exception Handle 24Exception Range 5
Execute Immediate 24EXIT 9For Loop 27FORALL 5
GOTO 6Handle Exception 5IF 20IN 5
Index by Table 5Insert Data 4IS 6Label 6
LIKE 2Loop 7MEMBER OF 3Multi line Command 1
MULTISET 7Not Null Variable 2NULL Statement 3Null Value 3
Number to Char 4Object Type 5Operator 1Output Print 2
Package 30Pause 1Predefined Exceptions 6Print 1
Program Block 4Prompt 1Raise 10Record Data Type 14
Repeat Until 2RETURNING Into 2rowtype 13Select Into 26
Server Output 1Set 2SQL FOUND 1SQL ISOPEN 1
SQL ROWCOUNT 1sqlcode 3SQLERRM 8SUBMULTISET 3
subtype 2Table of Char 5Table of Column 1Table of Date 1
Table of number 26Table of Object 1Table of rowtype 5Table of Type 18
Table of Varchar2 28Timing PL SQL 2Transaction 9Type 8
Update Data 17Utility Package 7Varchar Table 4Variable Declare 6
Variable Default Value 2Variable init 4Variable Scope 9Variable 4
varray 41When 3While Loop 17Your own Exception 7