Chapters

1. Getting started with Oracle Database
2. Getting started with PL/SQL
3. Anonymous PL/SQL Block
4. PL/SQL procedure
5. Data Dictionary
6. Dates
7. Working with Dates
8. DUAL table
9. JOINS
10. Handling NULL values
11. String Manipulation
12. IF-THEN-ELSE Statement
13. Limiting the rows returned by a query (Pagination)
14. Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)
15. Different ways to update records
16. Update with Joins
17. Functions
18. Statistical functions
19. Window Functions
20. Creating a Context
21. Splitting Delimited Strings
22. Collections and Records
23. Object Types
24. Loop
25. Cursors
26. Sequences
27. Indexes
28. Hints
29. Packages
30. Exception Handling
31. Error logging
32. Database Links
33. Table partitioning
34. Oracle Advanced Queuing (AQ)
35. constraints
36. Autonomous Transactions
37. Oracle MAF
38. level query
39. Hierarchical Retrieval With Oracle Database 12C
40. Data Pump
41. Bulk collect
42. Real Application Security
43. Assignments model and language
44. Triggers
45. Dynamic SQL

https://cdn.shopify.com/s/files/1/0298/0039/8988/files/OracleDatabaseNotesForProfessionals.pdf?844