Oracle Database Notes for Professionals

GoalKicker.com, 2018. — 118 p.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.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