Question

Download Free: Oracle Database notes for professionals book

Answer 1

Download Oracle Database E-book free Click Here

The Oracle® Database Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

Book created for educational purposes and is not affiliated with Oracle® Database group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

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