Oracle Database Notes for Professionals
The contents include: Getting started with Oracle Database, Data Dictionary, Dates, Working with Dates, DUAL table, JOINS,Handling NULL values, String Manipulation, 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, constraints, Autonomous Transactions, Oracle MAF, level query,Hierarchical Retrieval With Oracle Database C, Data Pump, Bulk collect, Real Application Security,Assignments model and language, Triggers, Dynamic SQL.
Author(s): GoalKicker.com
118 Pages
This note covers SQL, SQL Plus, Oracle data dictionary, Application programming, Integrity constraints and triggers and system architecture.
Author(s): University of California
66 Pages
