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