ORACLE SQL

SQL Create Table

SQL Select

SQL Insert Into

SQL Distinct

SQL Where

SQL And & Or

SQL Order By

SQL Update

SQL Delete

SQL Like

SQL In

SQL Between

SQL Aliases

SQL Joins

SQL Inner Join

SQL Left Join

SQL Right Join

SQL Full Join

SQL Union

SQL Constraints

SQL Not Null

SQL Unique

SQL Primary Key

SQL Foreign Key

SQL Check

SQL Create Index

SQL Drop

SQL Views

ORACLE SQL Functions

SQL Avg()

SQL Count()

SQL Max()

SQL Min()

SQL Sum()

SQL Group By

SQL Having

SQL Ucase()

SQL Lcase()

SQL Mid()

SQL Len()

SQL Round()

ORACLE PL/SQL

Basic PL/SQL

PL/SQL Advantages

PL/SQL Block Structure

PL/SQL Variable & Scope

PL/SQL Constant Declaration

PL/SQL serveroutput ON

PL/SQL Comment

PL/SQL Data Types

PL/SQL Data Types

Numeric Datatypes

Character Datatypes

Boolean Datatypes

Date/Time Datatypes

LOB types

PL/SQL Condition Looping

IF THEN ELSE Statement

IF THEN ELSIF Statement

PL/SQL Loop Statement

Basic LOOP

WHILE LOOP

FOR LOOP

PL/SQL Transaction

COMMIT

ROLLBACK

SAVEPOINT

AUTOCOMMIT

PL/SQL Cursors

Implicit Cursors

Explicit Cursors

For Loop Cursors

PL/SQL Exception

User Defined Exception

User Named Exception

Advance PL/SQL

PL/SQL Procedures

Procedure Syntax

Procedure Example

Procedure Drop

PL/SQL Functions

Function Syntax

Function Example

Function Drop

PL/SQL Packages

Packages Advantages

Packages Syntax

Packages Example

Packages Alter

Packages Drop

PL/SQL Triggers

Triggers Type

Triggers Syntax

Triggers Examples