Data Types
SELECT Statement
Literals (Constants)
DISTINCT
Declaring Variables
COUNT / SUM / MIN / MAX
Is Null / Is Not Null
WHERE Clause
Loops and Conditional Statements
"AND" Condition
Sequences (Autonumber)
"OR" Condition
Transactions
Combining "AND" with "OR"
Cursors
Functions (Built-In) (By Category)
"LIKE" Condition
Functions (Built-In) (Alphabetical)
"IN" Function
Oracle System Tables
BETWEEN Condition
EXISTS Condition
Primary Keys
GROUP BY
Foreign Keys
HAVING
Unique Constraints
ORDER BY (sort by)
Check Constraints
Indexes
JOINS (inner, outer)
Subqueries
Creating Functions
Creating Procedures
UNION Query
Creating Triggers
UNION ALL Query
Exception Handling
INTERSECT Query
Oracle Error Messages
MINUS Query
Grant/Revoke Privileges
UPDATE Statement
Roles (set of privileges)
INSERT Statement
Change Password
DELETE Statement
Synonyms (create, drop)
Tables (create, alter, drop, temp)
Views
Question & Answer
Nenhum comentário :
Postar um comentário