Oracle® Database Notes for Professionals book

Oracle® Database Notes for Professionals book
  • 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 PDF Book

Example book pages

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

118 pages, published on May 2018

158 Views

Leave a Reply

Your email address will not be published. Required fields are marked *