Oracle PL/SQL Important Topics

Oracle PL/SQL Important Topics

Oracle is a relational database technology.

PLSQL stands for "Procedural Language extensions to SQL", and can be used in Oracle databases. PLSQL is closely integrated into the SQL language, yet it adds programming constructs that are not native to SQL.

We've categorized Oracle and PLSQL into the following topics:

Data Types Literals (Constants) Declaring Variables Is Null / Is Not Null Primary Keys Foreign Keys Unique Constraints Check Constraints Indexes Functions (Built-In) - Alphabetical Functions (Built-In) - Category Creating Functions Creating Procedures Creating Triggers Exception Handling Oracle Error Messages Loops and Conditional Statements Sequences (Autonumber) Transactions Cursors Oracle System Tables Grant/Revoke Privileges Roles (set of privileges) Change Password Synonyms (create, drop) Question & Answer

SELECT Statement INSERT Statement UPDATE Statement DELETE Statement DISTINCT Clause WHERE Clause JOINING TABLES (inner/outer joins) Subqueries ORDER BY Clause (sorting) COUNT Function SUM Function MIN Function MAX Function "AND" Condition "OR" Condition Combining "AND" with "OR" Conditions "LIKE" Condition "IN" Condition BETWEEN Condition EXISTS Condition GROUP BY Clause HAVING Clause UNION Query UNION ALL Query INTERSECT Query MINUS Query Tables (create, alter, drop, temp) SQL Views