| Oracle PL / SQL » PL SQL |
| PL SQL |
| APPEND( 1 ) | Arithmetic Operators( 1 ) | Begin End Block( 1 ) | Boolean Expression( 3 ) | Break( 2 ) | Case( 3 ) |
| Char to Number( 1 ) | Char Varchar Compare( 5 ) | Column Type Variable( 2 ) | Comments( 1 ) | Compile Error( 1 ) | Concatenation Operator( 1 ) |
| Console Prompt Read( 4 ) | Constant Number( 2 ) | Data Insert( 3 ) | Data Type Convert( 10 ) | Data Type Define( 1 ) | Date Calculation( 1 ) |
| DATE Compare( 1 ) | Date Convert( 2 ) | DBMS_OUTPUT( 2 ) | Decode( 6 ) | Define( 3 ) | Delete Data( 1 ) |
| Dump( 1 ) | Errors Table( 1 ) | Exception Handle( 2 ) | Exception Range( 2 ) | Execute Immediate( 1 ) | EXIT( 5 ) |
| For Loop( 7 ) | GOTO( 1 ) | Handle Exception( 1 ) | IF( 5 ) | IN( 1 ) | Index by Table( 5 ) |
| Insert Data( 2 ) | Label( 2 ) | Multi line Command( 1 ) | Not Null Variable( 2 ) | NULL Statement( 2 ) | Null Value( 2 ) |
| Number to Char( 1 ) | Output Print( 2 ) | Pause( 1 ) | Predefined Exceptions( 3 ) | Print( 1 ) | Program Block( 4 ) |
| Prompt( 1 ) | Record Data Type( 5 ) | Repeat Until( 2 ) | rowtype( 3 ) | Select Into( 2 ) | Server Output( 1 ) |
| SQL FOUND( 1 ) | SQL ISOPEN( 1 ) | SQL ROWCOUNT( 1 ) | sqlcode( 1 ) | SQLERRM( 1 ) | Table of Char( 1 ) |
| Table of rowtype( 1 ) | Table of Varchar2( 7 ) | Timing PL SQL( 2 ) | Type( 1 ) | Update Data( 1 ) | Varchar Table( 2 ) |
| Variable Declare( 1 ) | Variable Default Value( 2 ) | Variable init( 3 ) | Variable Scope( 3 ) | Variable( 2 ) | When( 2 ) |
| While Loop( 5 ) | Your own Exception( 2 ) |