Oracle SQL – PLSQL

SQL

Data Types Select Statement CREATE Table
ALTER Table DROP Table UPDATE
INSERT DELETE DISTINCT
WHERE Clause AND Condition OR Condition
Combining AND with OR IN Function BETWEEN Condition
EXISTS Condition LIKE Condition GROUP BY
HAVING ORDER BY JOINS
UNION UNION ALL INTERSECT
MINUS Views Sequence
Primary Key Foreign Key Unique Constraint
Check Constraints Index Change User Password
Aggregate Functions DATE and TIME Functions Character / String Functions
Mathematical Fuctions Conversion Functions Analytical Functions
Miscellaneous Functions

PL-SQL

Data Types Literals (Constants) Declaring Variables
IS NULL IS NOT NULL Loop Statement
FOR Loop CURSOR FOR Loop WHILE Loop
EXIT Statement IF THEN ELSE Statement Case Statement
GOTO Statement Declare Cursor Open Cursor
Fetch Cursor Close Cursor Attributes of Cursor
Oracle System Tables Create Functions Create Procedures
Create Triggers BEFORE INSERT Trigger AFTER INSERT Trigger
BEFORE UPDATE Trigger AFTER UPDATE Trigger BEFORE DELETE Trigger
AFTER DELETE Trigger EXCEPTION Concepts Named System Exceptions
Named Programmer Exceptions WHEN OTHERS Clause Grant/Revoke Privilege
Roles Synonym Subquery
Aggregate Functions DATE and TIME Functions Character / String Functions
Mathematical Fuctions Conversion Functions Analytical Functions
Miscellaneous Functions

Aggregate Functions

SUM COUNT MIN
MAX AVG VARIANCE
STDDEV MEDIAN

DATE and TIME Functions

SYSDATE SYSTIMESTAMP TO_CHAR
TO_DATE TO_TIMESTAMP TO_TIMESTAMP_TZ
ADD_MONTHS LAST_DAY NEXT_DAY
ROUND TRUNC MONTHS_BETWEEN
CURRENT_DATE CURRENT_TIMESTAMP NEW_TIME
LOCALTIMESTAMP TZ_OFFSET FROM_TZ
DBTIMEZONE SESSIONTIMEZONE NUMTODSINTERVAL
NUMTOYMINTERVAL EXTRACT

Character / String Functions

Ascii AsciiStr Chr
Compose Concat Concat with ||
Convert Decompose Dump
Initcap Instr Length
Lower Lpad Ltrim
Replace Rpad Rtrim
Soundex Substr Translate
Trim Upper VSize

Mathematical Fuctions

Log ABS MOD
EXP SQRT POWER
ROUND (Numbers) TRUNC (Numbers) CEIL
FLOOR SIGN SIN
ASIN SINH COS
ACOS COSH TAN
ATAN TANH ATAN2
TO_BINARY_DOUBLE TO_BINARY_FLOAT LN
BITAND GREATEST LEAST
AVG Bin_To_Num Corr
Covar_pop Covar_samp COUNT
Cume_Dist Dense_Rank EXTRACT
MAX MEDIAN MIN
RANK Remainder ROUND (Dates)
STDDEV SUM TRUNC (Dates)
Var_pop Var_samp Variance

Conversion Functions

TO_NUMBER TO_CHAR TO_SINGLE_BYTE
TO_MULTI_BYTE ROWIDTOCHAR ROWIDTONCHAR
NVL NVL2 DECODE
TRANSLATE Cast Coalesce
HEXTORAW Bin_To_Num CharToRowid
From_Tz NumToDSInterval NumToYMInterval
RawToHex To_Clob To_Date
To_DSInterval To_Lob To_NClob
To_Timestamp To_Timestamp_Tz To_YMInterval

Analytical Functions

ROWNUM ROW_NUMBER ORDER
GROUP BY HAVING GROUPING
GROUPING_ID Table Joins WHERE
FIRST_VALUE LAST_VALUE First
Last Nulls First Nulls Last
RANGE RANK DENSE_RANK
PERCENT_RANK PARTITION_BY OVER
PERCENTILE_CONT PERCENTILE_DISC ROLLUP
UNBOUNDED SPREADSHEET MODEL
CUBE CUME_DIST NTILE
LEAD LAG

Miscellaneous Functions

USER SQLERRM SQLCODE
BFilename Cardinality Group_ID
LNNVL NANVL NULLIF
Sys_Context Uid UserEnv