Oracle PL/SQL:
1. Procedure ,Function ,Triggers and Packages
2. Cursor, Ref Cursor
3. Collections (Nested table ,associated array, varrys)
4. Query optimization
5. Knowledge on xml parsing and xml generating
6. Exception Handling
7. Dynamic SQL
8. Oracle inbuilt Packages like UTL packages.