SQL Topics Basic SQL Select Statement Restricting and Sorting Data Single Row Functions Group Functions SQL Loader External Tables Analytical Functions Set Operators Sub Queries Joins Pseudo Columns SQL PLUS Commands DDL DML TCL Constraints Global Temporary Table DCL Views Materialized Views Synonyms Sequence Index Hints Table Partitioning Virtual Column Index Organized Table PLSQL Topics Anonymous Block Variable Declaration %type %row type Record Control Statements Nested Block Bulk collect Bulk Bind with save exceptions Execute Immediate Bind variable UTL_FILE XML Stored Procedure IN OUT IN/OUT Local Procedure Forward Declaration Cursor Ref cursor Pragma Autonomous_Transaction Functions pipelined table functions Packages Spec Body dbms_jobs Exception Handling Trigger LOGON LOGOFF Compound trigger Mutating table error Trainer Karthick Ravichandran Msc(IT) Associate - Cognizant 9444999041 karthick.ravichandran.msc@gmail.com www.greenstechnologys.com/oracle-training.html www.oraclechennai.com