DUAL table FETCH FIRST ROWNUM NVL NVL2 DECODE CASE expression TO_CHAR TO_DATE TO_NUMBER

INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN CROSS JOIN Self join Subquery Correlated subquery EXISTS Scalar subquery

CONNECT BY START WITH LEVEL pseudocolumn SYS_CONNECT_BY_PATH CONNECT_BY_ROOT ROW_NUMBER analytic RANK analytic DENSE_RANK analytic LAG analytic LEAD analytic

GROUP BY HAVING ROLLUP CUBE GROUPING SETS LISTAGG PIVOT UNPIVOT UNION MINUS

IDENTITY column Sequence Synonym View Materialized view Global temporary table Virtual column Invisible column Constraint deferrable Function-based index

INSERT ALL MERGE RETURNING INTO COMMIT ROLLBACK SAVEPOINT SET TRANSACTION SELECT FOR UPDATE Flashback query AS OF Error logging LOG ERRORS

JSON_OBJECT JSON_ARRAY JSON_VALUE JSON_QUERY JSON_TABLE IS JSON constraint XMLTYPE XMLQUERY XMLTABLE JSON_TRANSFORM

EXPLAIN PLAN DBMS_XPLAN display Optimizer hint Index skip scan concept Bitmap index Partition pruning Virtual private database concept Fine-grained auditing concept Roles and privileges Row limiting pagination