Basic elements of SQL
Literals
Character string literals
Unicode string literals
Integer literals
Numeric literals
Date/time literals
Extended syntax
Interval literals
Data types
Working with Numeric and Decimal data types
NUMERIC data type
Calculating precision, scale, length
Configuring MINIMUM SCALE in IP
Operators
Scalar functions
Nulls
Nullability
Pseudo columns
Schema object names and qualifiers
Quoted identifiers
Bracket-delimited identifiers
Referring to schema objects and parts
Comments
C-Style comments
Oracle-Style comments
Operators
Unary and Binary operators
Arithmetic operators
Concatenation operator
Comparison operators
ESCAPE clause in LIKE operator
Logical operators
Set operators
Operator precedence
Condition evaluation
Functions
Scalar functions
Numeric functions
String functions
Time / date functions
System functions
Aggregate functions
CAST
CONVERT
DECODE
DENSE_RANK
IFNULL, ISNULL, NVL
RANK
ROW_NUMBER
User-defined functions
Expressions, conditions, and queries
Expressions
Simple expressions
Compound expressions
CASE
Simple CASE function
Searched CASE function
Conditions
Subqueries
IN predicate
EXISTS predicate
ORDER BY clause
UNIQUE predicate
Correlated subqueries
Subquery in FROM clause
Joins
SQL statements
DDL statements
ALTER TABLE
CREATE INDEX
CREATE TABLE
CREATE VIEW
DROP INDEX
DROP TABLE
DROP VIEW
DML statements
CALL
DELETE
INSERT
SELECT
UPDATE
DCL statements
GRANT
REVOKE
CREATE ROLE
CREATE USER
DROP ROLE
DROP USER
Non-Supported SQL-92 functionality
SQL standards compliance
Handling of NULLS
FOR UPDATE clause
Schema information
CREATE TABLE syntax
SELECT syntax
Views
Data types
Value expressions
Special values
Value functions
Date/Time functions
Advanced value expressions
NULLIF
COALESCE
Row value constructor
DEFAULT value
Rank functions
Predicates
Join and Union operations
INTERSECT
CORRESPONDING
EXCEPT
Join operators
Supported Join operators
Unsupported join operators
Limitations on OUTER JOIN
Limitations on UNION
Limitations on JOIN on views
Transaction control statements
COMMIT
ROLLBACK
Basic elements of SQL
ROLLBACK