sql

Basic SELECT statement Arithmetic expressions and NULL values Column alias Concatenation operator Literal character string Alternative quote operator DISTINCT keyword DESCRIBE command

Limit the retrieve rows Sort the rows Substitution variables

Single-row SQL Functions Character Functions Number Functions Working with dates Date Functions

Implicit and explicit data type conversion TO_CHAR, TO_DATE, TO_NUMBER functions Nested Functions General Functions CASE and DECODE Conditional expressions

Group Functions MIN MAX, COUNT, AVG,DISTINCT within group functions NULL values in a group functions

Types of JOINS Natural join Self-Join Non-equijoin Outer join Cartesian Products

Single row subquery Group Function in subquery HAVING clause with subquery Multiple-row subquery NULL values in Subquery

UNION and UNION ALL INTERSECT MINUS ORDER BY clause

INSERT, UPDATE, DELETE TRUNCATE and COMMIT ROLLBACK and SAVEPOINT Read consistency FOR UPDATE clause

Naming rules CREATE Table Data Types Constraint NOT NULL PRIMARY KEY FOREIGN KEY UNIQUE,ALTER Table Create table using a subquery

Views Sequence Index Synonyms

Creating a role Object Privileges Revoking object privileges

Managing constraints Creating Index Performing flashback operations Creating and using external tables

Table information Column information Constraint information View information Sequence Information Synonym information Comment to a table

Unconditional INSERT Pivoting INSERT INSERT ALL Merging rows Tracking the chnages

INTERVAL data types EXTRACT TZ_OFFSET FROM_TZ TO_TIMESTAMP TO_YMINTERVAL TO_DSINTERVAL

Using scalar subquery correlated subqueries EXISTS and NOT EXISTS WITH clause

REGEXP_LIKE REGEXP_REPLACE REGEXP_INSTR REGEXP_SUBSTR Accessing subexpressions REGEXP_COUNT