Monday, 16 June 2014

SQL & PLSQL
SQL
  •  INTRODUCTION TO SQL
  • DDL COMMANDS
  • DML COMMANDS
  • DCL COMMANDS
  • BASIC QUERIES
  • SINGLE ROW FUNCTIONS
  • GROUP FUNCTIONS (MORE ABOUT SQL)
  • JOINS
  • VIEWS
  • SEQUENCES
  • TRANSACTION CONTROL COMMANDS
  • SYNONYM
  • SET OPERATORS
  • ROWID and ROWNUM
  • INDEX
  • ANALYTICAL FUNCTIONS 
PLSQL
  • INTRODUCTION TO PL/SQL
  • VARIABLES AND CONSTANTS
  • CONDITIONS AND LOOPS 
  • CURSORS 
  • EXCEPTION HANDLING
  • PROCEDURES
  • USER DEFINED FUNCTIONS
  • PACKAGES
  • DATABASE TRIGGERS
  • DYNAMIC SQLBULK COLLECT
  • COLLECTIONS
  • UTL FILE
  • SQL * Loader 

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)