List of topics for learning and test:

1. Introduction to PL/SQL
2. Creating and Running PL/SQL Code
3. Language Fundamentals
4. Conditional and Sequential Control
5. Iterative Processing with Loops
6. Exception Handlers
7. Working with Program Data
8. Strings
9. Numbers
10. Dates and Timestamps
11. Records
12. Collections
13. Miscellaneous Datatypes
14. DML and Transaction Management
15. Data Retrieval
16. Dynamic SQL and Dynamic PL/SQL
17. Procedures Functions and Parameters
18. Packages
19. Triggers
20. Managing PL/SQL Code
21. Optimizing PL/SQL Performance
22. I/O and PL/SQL
23. Application Security and PL/SQL
24. PL/SQL Architecture
25. Globalization and Localization in PL/SQL
26. Object-Oriented Aspects of PL/SQL
27. Calling Java from PL/SQL
28. External Procedures
29. Oracle/PLSQL Functions
30. Keys Constraints
31. Synonyms Privileges Passwords and Roles
32. Indexes
33. Database Administration
34. Functions, Procedures and Cursors
35. Variables constants comments literals
36. FOR Loop WHILE Loop IF-THEN-ELSE
37. Sequences Commits and rollbacks Exception
38. System Tables
39. Comparison Operators
40. SELECT, INSERT, INSERT ALL, DELETE, UPDATE and TRUCATE
41. UNION, UNION ALL, INTERSECT and MINUS
42. Subqueries
43. PIVOT Clause
44. Inner and Outer joins
45. ALIASES DISTINCT Clause
46. FROM, WHERE, ORDER BY, GROUP BY, and HAVING Clauses
47. Conditions
48. Tables and Views
49. Functions