| Oracle PL / SQL |
| Select Query |
| ALL( 1 ) | AND( 3 ) | ANY( 1 ) | Arithmetic Operators Query( 4 ) | AS( 2 ) | BETWEEN AND( 4 ) |
| Calculation in Query( 1 ) | Case Query( 3 ) | Char Case( 1 ) | Char Compare( 2 ) | Column alias( 3 ) | Column Concatenation( 2 ) |
| Column Names( 1 ) | Comparison Operators( 1 ) | Date Add( 1 ) | Date Calculation Query( 7 ) | Derive values( 1 ) | DISTINCT( 4 ) |
| EXISTS( 2 ) | GROUP BY( 10 ) | HAVING( 7 ) | Like( 5 ) | Logical Operators( 1 ) | Nesting Functions( 2 ) |
| NOT( 2 ) | Null Value Calculation( 1 ) | Null Value Compare( 1 ) | Null Value Concatanation( 1 ) | Number Format( 1 ) | OR( 2 ) |
| Order By( 5 ) | Query Date Compare( 3 ) | Query IN( 3 ) | Query Select Columns( 2 ) | Quote( 2 ) | Select( 4 ) |
| Where( 5 ) | Wild Card( 4 ) |
| Insert Delete Update |
| Delete Subquery( 1 ) | DELETE WHERE( 4 ) | INSERT Column Name( 4 ) | INSERT with Functions( 2 ) | Insert with subquery( 1 ) | Update All( 1 ) |
| UPDATE Set Clause( 4 ) | Update subquery( 2 ) | UPDATE WHERE( 3 ) |
| Subquery |
| Correlated Subquery( 3 ) | Subquery ALL( 2 ) | Subquery ANY( 2 ) | Subquery Basics( 20 ) | Subquery IN( 2 ) | Virtual Table( 1 ) |
| Hierarchical Query |
| Indent( 1 ) | Level( 3 ) | Nodes Branches( 2 ) | Root( 1 ) | Start With Connect( 3 ) |
| Table |
| Add Column( 2 ) | Alter Table( 6 ) | Change Column Size( 1 ) | Change Column Type( 1 ) | chartorowid( 1 ) | Column Default Value( 2 ) |
| Comment Table( 2 ) | Copy Table( 5 ) | Create Table( 4 ) | CSV Table( 3 ) | Describe( 1 ) | Drop Columns( 1 ) |
| Drop Table( 1 ) | DUAL Table( 1 ) | External Table( 1 ) | Rename Column( 1 ) | Row Count( 1 ) | ROWID( 2 ) |
| ROWNUM( 4 ) | SAVEPOINT( 2 ) | SYNONYM( 1 ) | Table Reference( 1 ) | Table space( 2 ) | Table Statistics( 1 ) |
| Temporary Table( 3 ) | Transaction Rollback Commit( 2 ) |
| Table Joins |
| ANSI SQL 92 Joins( 5 ) | Cartesian product( 3 ) | Cross joins( 1 ) | Equijoins( 1 ) | Full Outer Join( 1 ) | Inner Joins( 1 ) |
| Left Outer Join( 2 ) | Outer Joins( 3 ) | Right Outer Joins( 1 ) | Self Joins( 1 ) | Table Join Basics( 5 ) | Table Join Column( 1 ) |
| View |
| Create View( 3 ) | Query View( 1 ) | Updatable View( 1 ) | Update View( 1 ) |
| Aggregate Functions |
| Aggregate Functions Basics( 6 ) | AVG( 5 ) | COUNT( 5 ) | GROUP Function( 2 ) | MAX( 3 ) | MIN( 5 ) |
| SUM( 3 ) |
| Char Functions |
| ASCII( 1 ) | ASCIISTR( 2 ) | Char Length( 1 ) | COMPOSE( 1 ) | CONCAT( 1 ) | Convert( 1 ) |
| decompose( 1 ) | I18N( 2 ) | INITCAP( 3 ) | INSTR( 6 ) | LENGTH( 1 ) | LOWER( 2 ) |
| LPAD( 2 ) | LTRIM( 2 ) | NVL( 5 ) | NVL2( 2 ) | REPLACE( 4 ) | RPAD( 1 ) |
| RTRIM( 2 ) | SOUNDEX( 3 ) | String Concatenate( 1 ) | SUBSTR( 5 ) | Translate( 5 ) | TRIM( 7 ) |
| UNISTR( 1 ) | UPPER( 2 ) | VSIZE( 1 ) |
| Numeric Math Functions |
| ABS( 2 ) | ACOS( 2 ) | ASIN( 2 ) | ATAN( 2 ) | ATAN2( 1 ) | BIN_TO_NUM( 4 ) |
| BITAND( 5 ) | CEIL( 3 ) | COS( 3 ) | COSH( 2 ) | EXP( 3 ) | FLOOR( 2 ) |
| hextoraw( 1 ) | LN( 2 ) | LOG( 4 ) | MOD( 5 ) | POWER( 3 ) | ROUND( 9 ) |
| SIGN( 4 ) | SIN( 2 ) | SINH( 2 ) | SQRT( 3 ) | TAN( 2 ) | TANH( 2 ) |
| TRUNC( 7 ) |
| Analytical Functions |
| Aggregrate Analytical( 10 ) | Analytical Functions Basics( 12 ) | Centered Average( 1 ) | Compute( 3 ) | Corr( 1 ) | COVAR_POP( 1 ) |
| COVAR_SAMP( 1 ) | Cube( 5 ) | CUME_DIST( 2 ) | Cumulative Sum( 2 ) | CURRENTV( 2 ) | DENSE_RANK( 7 ) |
| First Last Value( 4 ) | First Last( 1 ) | GROUPING SETS( 2 ) | GROUPING( 5 ) | GROUPING_ID( 4 ) | IGNORE NAV KEEP NAV( 1 ) |
| IS PRESENT( 1 ) | LAG LEAD( 4 ) | Measure( 3 ) | MEDIAN( 1 ) | Model( 2 ) | Moving Average( 1 ) |
| NTILE( 6 ) | NULLs First( 3 ) | NULLs Last( 4 ) | Over( 1 ) | PARTITION( 3 ) | PERCENTILE_DISC( 1 ) |
| PERCENT_RANK( 3 ) | PRESENTV( 1 ) | Rank Row( 1 ) | Rank( 9 ) | Ratio Portion( 1 ) | RATIO_TO_REPORT( 6 ) |
| REGR_AVGX( 2 ) | REGR_AVGY( 1 ) | REGR_COUNT( 2 ) | REGR_INTERCEPT( 2 ) | REGR_R2( 2 ) | REGR_SLOPE( 2 ) |
| REGR_SXX( 2 ) | REGR_SXY( 2 ) | REGR_SYY( 3 ) | Rollup( 8 ) | ROW_NUMBER( 5 ) | RULES UPDATE( 1 ) |
| STATS_MODE( 1 ) | STATS_WSR_TEST( 3 ) | STDDEV( 2 ) | STDDEV_POP( 1 ) | STDDEV_SAMP( 1 ) | Top Values( 1 ) |
| UNBOUNDED FOLLOWING( 1 ) | VARIANCE( 2 ) | VAR_POP( 1 ) | VAR_SAMP( 1 ) |
| 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 ) |
| Data Type |
| Binary Data Type( 1 ) | Boolean( 2 ) | Cast( 1 ) | CHAR( 3 ) | Clob( 1 ) | Date( 2 ) |
| Integer( 1 ) | IS INFINITE( 1 ) | IS NAN( 1 ) | IS NULL Value( 1 ) | IS NULL( 2 ) | Long( 1 ) |
| National Char( 2 ) | Number Type( 3 ) | Numeric Formatting( 17 ) | Timestamp( 6 ) | TO_BINARY_DOUBLE( 1 ) | TO_BINARY_FLOAT( 1 ) |
| TO_Char Date( 16 ) | TO_CHAR Number( 3 ) | TO_CLOB( 1 ) | TO_Date( 5 ) | TO_MULTI_BYTE( 1 ) | TO_NCHAR( 1 ) |
| TO_NCLOB( 1 ) | TO_NUMBER( 3 ) | TO_SINGLE_BYTE( 1 ) | VARCHAR2( 1 ) |
| Cursor |
| Close Cursor( 1 ) | Cursor Fetch( 3 ) | CURSOR FOR Loop( 4 ) | Cursor FOUND( 1 ) | Cursor ISOPEN( 1 ) | Cursor Not Found( 2 ) |
| Cursor Open( 1 ) | Cursor parameters( 2 ) | Cursor Update( 1 ) | Cursor Value( 1 ) | Explicit Cursor( 1 ) | Implicit Cursor( 2 ) |
| Nested Cursor( 1 ) | Reference Cursor( 1 ) |
| Result Set |
| Intersect( 3 ) | Loop Result set( 1 ) | Minus( 3 ) | Union all( 3 ) | UNION( 3 ) |
| Regular Expressions |
| alnum( 1 ) | Alpha( 3 ) | Brackets( 4 ) | Case( 3 ) | Control Letter( 1 ) | Digit( 4 ) |
| Escape( 1 ) | Group( 5 ) | NOT( 4 ) | OR( 2 ) | Punct Print( 2 ) | Range( 1 ) |
| REGEXP_INSTR( 15 ) | REGEXP_LIKE( 4 ) | REGEXP_REPLACE( 3 ) | REGEXP_SUBSTR( 3 ) | Repeat Operator( 4 ) | Space( 1 ) |
| Wild Card( 15 ) | Word Start End( 4 ) |
| Date Timezone |
| ADD_MONTHS( 4 ) | CURRENT_DATE( 1 ) | CURRENT_TIMESTAMP( 1 ) | Date Default Format( 7 ) | Date Format( 1 ) | Date Time Interval( 1 ) |
| Day Calculation( 1 ) | DBTIMEZONE( 1 ) | EXTRACT( 8 ) | FROM_TZ( 1 ) | INTERVAL( 4 ) | LAST_DAY( 3 ) |
| LOCAL TIME ZONE( 2 ) | LOCALTIMESTAMP( 1 ) | MONTHS_BETWEEN( 3 ) | NEW_TIME( 1 ) | NEXT_DAY( 5 ) | NLS_DATE_FORMAT( 1 ) |
| numtodsinterval( 6 ) | numtoyminterval( 4 ) | ROUND Date( 2 ) | SESSIONTIMEZONE( 1 ) | SYSDATE( 2 ) | SYSTIMESTAMP( 1 ) |
| Time Zone( 6 ) | TO_DSINTERVAL( 2 ) | TO_TIMESTAMP( 5 ) | TO_TIMESTAMP_TZ( 2 ) | TO_YMINTERVAL( 4 ) | TRUNC Date( 4 ) |
| TZ_OFFSET( 1 ) |
| Sequence |
| Alter Sequence( 1 ) | Create Sequence( 1 ) | Drop Sequence( 1 ) | Sequence Increment( 1 ) | Sequence Properties( 3 ) | Sequence Start( 1 ) |
| Sequence Value( 5 ) |
| Index |
| Alter Index( 1 ) | Create Index( 2 ) | Drop Index( 1 ) | Index STATISTICS( 1 ) | Rename Index( 1 ) |
| Constraints |
| Add Check Constraint( 1 ) | Add Constraint( 2 ) | Add Foreign Key( 1 ) | Add Primary Key( 3 ) | Constraint Check( 6 ) | Constraint Types( 2 ) |
| Contraint Name( 2 ) | Create Foreign Key( 2 ) | Create Primary Key( 2 ) | Defer Constraint( 2 ) | DELETE CASCADE( 1 ) | DELETE SET NULL( 2 ) |
| Drop Cascade( 2 ) | Drop Constraint( 2 ) | Drop Foreign Key( 2 ) | Drop Primary Key( 1 ) | Enable Disable Primary Key( 2 ) | Foreign Key( 2 ) |
| Name for Primary Key( 1 ) | Primary Key( 4 ) | Unique( 3 ) |
| Store Procedure Function |
| Default Parameter Value( 1 ) | Execute( 1 ) | Function Definition( 2 ) | Function Parameters( 2 ) | Function Return( 3 ) | IN Parameter( 1 ) |
| Parameter IN( 1 ) | Parameter OUT( 1 ) | Procedure Definition( 2 ) | Procedure Parameters( 1 ) | Reference Your Function( 1 ) |
| Trigger |
| After Delete Trigger( 1 ) | After Insert Trigger( 1 ) | After Update Trigger( 2 ) | Audit Log Table( 1 ) | Before Delete Trigger( 1 ) | Before Insert Trigger( 2 ) |
| Before Trigger( 1 ) | Before Update Trigger( 1 ) | Business Logic Trigger( 2 ) | Create Trigger( 1 ) | Disable Trigger( 2 ) | Drop Trigger( 1 ) |
| Enable Trigger( 2 ) | Log Trigger( 2 ) | Old New Value( 1 ) | Triggerable Actions( 1 ) |
| Object Oriented Database |
| DEREF( 1 ) | Insert( 3 ) | Object Column( 2 ) | Object Method( 2 ) | Object Table Insert( 1 ) | Object Table( 2 ) |
| Object View( 1 ) | Object( 1 ) | RAISE Exception( 3 ) | Ref( 3 ) | Reference Object( 3 ) | Select( 6 ) |
| Self( 1 ) | Table( 3 ) | Update( 3 ) | Value Function( 1 ) |
| User Previliege |
| Create User( 2 ) | Current User( 1 ) | Drop User( 1 ) | Grant Permission( 2 ) | Lock Unlock Account( 1 ) | Revok Roles( 1 ) |
| REVOKE REFERENCES( 1 ) | System Privileges( 1 ) | User Create( 1 ) | User Password( 1 ) |
| System Tables |
| ALL_CATALOG( 1 ) | ALL_SEQUENCES( 1 ) | ALL_SYNONYMS( 1 ) | ALL_TABLES( 1 ) | CAT( 1 ) | DBA_SYNONYMS( 1 ) |
| DBA_Tables( 1 ) | ROLE_SYS_PRIVS( 1 ) | ROLE_TAB_PRIVS( 2 ) | SYS_EXTRACT_UTC( 1 ) | USER_CATALOG( 1 ) | USER_COL_PRIVS_MADE( 1 ) |
| USER_COL_PRIVS_RECD( 1 ) | USER_CONSTRAINTS( 1 ) | USER_ERRORS( 1 ) | USER_OBJECTS( 1 ) | USER_ROLE_PRIVS( 2 ) | USER_SEQUENCES( 1 ) |
| USER_SYNONYMS( 1 ) | USER_SYS_PRIVS( 1 ) | USER_TABLES( 3 ) | USER_TAB_COLUMNS( 1 ) | USER_TAB_COMMENTS( 1 ) | USER_TAB_PRIVS_MADE( 2 ) |
| USER_TAB_PRIVS_RECD( 1 ) | USER_UPDATABLE_COLUMNS( 1 ) | USER_VIEWS( 1 ) |
| Report Column Page |
| COLSEP( 1 ) | Column Format Clear( 1 ) | Column Heading Name( 1 ) | Column Heading Size( 1 ) | Column Length( 1 ) | Column Number Format( 7 ) |
| Column Word Wrap( 1 ) | Heading( 1 ) | Line size( 2 ) | Line Width( 1 ) | Page Size( 2 ) |
| SQLPlus |
| Accept( 2 ) | autotrace( 1 ) | Edit( 1 ) | Feedback( 1 ) | Get( 1 ) | Login( 1 ) |
| Query Rewrite( 1 ) | Quit( 1 ) | Save( 1 ) | Start( 2 ) | Timing( 1 ) |
| XML |
| XMLElement( 1 ) |