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

*The digital edition does not include access codes to additional material or programs mentioned in the book.