Oracle

ORACLE SQL

 

SQL Commands:

1) DDL
2) DML
3) DRL
4) DCL
5) TCL

Constraints:

• Not Null
• Unique
• Primary Key
• Foreign Key
• Check

Functions:

• Character Functions
• Number Functions
• Data Functions
• Group Functions

Joins:

• Equi Join
• Non Equi Join
• Outer Join
• Self Join

Sub Queries:

• Single Row Sub Query
• Multiple Row Sub Query
• Co – related Sub Query

Objects:

• Views
  • Simple views
  • Complex views
  • Read only views
• Sequences
• Synonyms
• Indexes

PL/SQL

• Advantage of Pl/SQL
• The generic PL/SQL block
• Control Structures

Cursors

• Introduction to Cursors
• Types of Cursors
• Implicit Cursors
• Explicit Cursors
• Cursor Attributes
• Cursor For Loops
• Parameterized cursors

Locks

• Types of locks
• Levels of locks
• Explicit Locking
• Select for update statement
• Using lock table statement
• Releasing locks

Exceptions

• Introduction to Exceptions
• Types of Exceptions
• Oracle Predefined Exceptions
• Oracle Non- Predefined Exceptions
• User- Defined Exceptions
• Using Raise_ Application_Error

Triggers

• Introduction to Triggers
• Types of Triggers
• Developing Triggers
• Using conditional predicates
• Using old and new qualifiers
• Instead of Triggers

Procedures

• Benefits of sub-programs
• Developing procedures
• Procedure parameter modes
• Creating procedure with Parameters
• DEFAULT option for Parameters
• Invoking procedure from Anonymous Pl/SQL Block

Functions

• Overview of Functions
• Creating functions
• Executing Functions
• Using functions in SQL Expressions
• Comparing Procedure and Functions

Packages

• Introduction to Packages
• Components of Package
  • Packages Specification
  • Package Body
• Developing packages
• Public and private constructs
• Invoking package constructs
• Guidelines for developing packages
• Advantages of packages