Oracle SQL and PL/SQL

Oracle Database Objects

Datatypes
 Simple
 Complex

Tables
Constraints
Indexes
Sequences
Synonyms
Views
Metadata Views


The select statements
dual,null,pseudo-columns
Where clause
Logical Operators
Conditional Comparisons
ORDER BY Clause
Sorting Methods
Joins
Cross/Cartesian Join
Natural/Inner Join
Outer Join
Self Join
Equi-Join,Anti-Join and Range Joins
Mutable and comples joins
GROUP BY clauses

Subqueries

DML Operations
Insert,Update,delete,truncate
Transactional Control
Commit vs Rollback


PL/SQL
functions
packages
triggers
cursors
dbms_* packages

 

 

Built in functions
String Functions
Number Functions
Date Functions
Other Functions
Datatype Conversion Functions
Custom Function


 

Comments