Oracle Database Notes for Professionals

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.

Table of Contents

• Getting started with Oracle Database
• Getting started with PL/SQL
• Anonymous PL/SQL Block
• PL/SQL procedure
• Data Dictionary
• Dates
• Working with Dates
• DUAL table
• JOINS
• Handling NULL values
• String Manipulation
• IF-THEN-ELSE Statement
• Limiting the rows returned by a query (Pagination)
• Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)
• Different ways to update records
• Update with Joins
• Functions
• Statistical functions
• Window Functions
• Creating a Context
• Splitting Delimited Strings
• Collections and Records
• Object Types
• Loop
• Cursors
• Sequences
• Indexes
• Hints
• Packages
• Exception Handling
• Error logging
• Database Links
• Table partitioning
• Oracle Advanced Queuing (AQ)
• constraints
• Autonomous Transactions
• Oracle MAF
• level query
• Hierarchical Retrieval With Oracle Database 12C
• Data Pump
• Bulk collect
• Real Application Security
• Assignments model and language
• Triggers
• Dynamic SQL

Download Free PDF / Read Online