Oracle SQl & PL/SQL

1.Oracle SQL Sub Language,Command Categories and Data Types with Examples.

2.SQL Constraints,Indexes,Sequences with Examples.

3.Widlcards,Clauses,Joins with Examples.

4.SQL Functions,Sub Queries,Views,Materialized Views,Synonyms With Examples.

5.PLSQL Introduction with Basic Syntax,Data Types,Variables,Constants and Operators with Examples.

6.PLSQL Conditions,Loops,Strings,Arrays with examples.

7.PL/SQL Procedurs,Functions,Cursors,Records with Examples.

8.Exceptions,Triggers,Packages,Collections,Nested Tables With Examples.

9.PLSQL Transactions,Date&Time,DBMS Output with examples.