PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL

PL SQL /

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