PL/SQL: Understanding PL/SQL Collections.

·Understanding PL/SQL Collections.

·Defining PL/SQL Record.

·PL/SQL Tables.

· Referencing PL/SQL Table.

·Write a PL/SQL Program to i.Hike the Employee salary as 100 if employee salary is in between 0 to 1000.  ii.Hike the Employee salary as 200 if employee salary is in between 1001 to 2000.   iii.Other than these two condition hike 300 insert the update employee details into the those table.

· Nested type Collection.

·Clauses In PL/SQL.

·Difference between Anonymous and Named PL/SQL block.

·Subprograms in PL/SQL.