Curriculam

• 1Z0-061 Oracle Database 12c: SQL Fundamentals
• 1Z0-047 Oracle Database SQL Expert
• 1Z0-117 Oracle Database 11g Release 2: SQL Tuning
• 1Z0-051 Oracle Database 11g: SQL Fundamentals I
• 1Z0-147 Program with PL/SQL
• 1Z0-144 Oracle Database 11g: Program with PL/SQL

• 1Z0-062 Oracle Database 12c: Installation and Administration
• 1Z0-063 Oracle Database 12c: Advanced Administration
• 1Z0-051 Oracle Database 11g: SQL Fundamentals I
• 1Z0-052 Oracle Database 11g: Administration I
• 1Z0-053 Oracle Database 11g: Administration II

• 1Z0-048 Oracle Database 10g R2: Real Application Clusters for Administrators Oracle SQL and PLSQL Course Syllabus
  Module 1: Writing Basic SQL SELECT Statements
  • Basic SELECT Statement
  • Selecting All Columns
  • Selecting Specific Columns
  • Writing SQL Statements
  • Column Heading Defaults
  • Arithmetic Expressions
  • Using Arithmetic Operators
  • Operator Precedence
  • Using Parentheses
  • Defining a Null Value
  • Null Values in Arithmetic Expressions
  • Defining a Column Alias
  • Using Column Aliases
  • Concatenation Operator
  • Using the Concatenation Operator
  • Literal Character Strings
  • Using Literal Character Strings
  • Duplicate Rows
  • Eliminating Duplicate Rows
  Module 2: Restricting and Sorting Data
  • Limiting Rows Using a Selection
  • Limiting the Rows Selected
  • Using the WHERE Clause
  • Character Strings and Dates
  • Comparison Conditions
  • Using Comparison Conditions
  • Other Comparison Conditions
  • Using the BETWEEN Condition
  • Using the IN Condition
  • Using the LIKE Condition
  • Using the NULL Conditions
  • Logical Conditions
  • Using the AND Operator
  • Using the OR Operator
  • Using the NOT Operator
  • Rules of Precedence
  • ORDER BY Clause
  • Sorting in Descending Order
  • Sorting by Column Alias
  • Sorting by Multiple Columns
  Module 3: . Single-Row Functions
  • SQL Function
  • Two Types of SQL Functions
  • Single-Row Functions
  • Single-Row Functions
  • Character Functions
  • Character Functions
  • Case Manipulation Functions
  • Using Case Manipulation Functions
  • Character-Manipulation Functions
  • Using the Character-Manipulation Functions
  • Number Functions
  • Using the ROUND Function
  • Using the TRUNC Function
  • Using the MOD Function
  • Working with Dates
  • Arithmetic with Dates
  • Using Arithmetic Operators with Dates
  • Date Functions
  • Using Date Functions
  • Practice 3, Part One:
  • Conversion Functions
  • Implicit Data Type Conversion
  • Explicit Data Type Conversion
  • Using the TO_CHAR Function with Dates
  • Elements of the Date Format Model
  • Using the TO_CHAR Function with Dates
  • Using the TO_CHAR Function with Numbers
  • Using the TO_NUMBER and TO_DATE Functions
  • RR Date Format
  • Example of RR Date Format
  • Nesting Functions General Functions
  • NVL Function
  • Using the NVL Function
  • Using the NVL2 Function
  • Using the NULLIF Function
  • Using the COALESCE Function
  • Conditional Expressions
  • The CASE Expression
  • Using the CASE Expression
  • The DECODE Function
  • Using the DECODE Function
  Module 4: Displaying Data from Multiple Tables
  • Obtaining Data from Multiple Tables
  • Cartesian Products
  • Generating a Cartesian Product
  • Types of Joins
  • Joining Tables Using Oracle Syntax
  • What is an Equijoin?
  • Retrieving Records with Equijoins
  • Additional Search Conditions Using the AND Operator
  • Qualifying Ambiguous Column Names
  • Using Table Aliases
  • Joining More than Two Tables
  • Non-Equijoins
  • Retrieving Records with Non-Equijoins
  • Outer Joins Outer Joins Syntax
  • Using Outer Joins
  • Self Joins
  • Joining a Table to Itself
  • Joining Tables Using SQL: 1999 Syntax
  • Creating Cross Joins
  • Creating Natural Joins
  • Retrieving Records with Natural Joins
  • Creating Joins with the USING Clause
  • Retrieving Records with the USING Clause
  • Creating Joins with the ON Clause
  • Retrieving Records with the ON Clause
  • Creating Three-Way Joins with the ON Clause
  • INNER Versus OUTER Joins
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • Additional Conditions
  Module 5: Aggregating Data Using Group Functions
  • What Are Group Functions?
  • Types of Group Functions
  • Group Functions Syntax
  • Using the AVG and SUM Functions
  • Using the MIN and MAX Functions
  • Using the COUNT Function
  • Using the DISTINCT Keyword
  • Group Functions and Null Values
  • Using the NVL Function with Group Functions
  • Creating Groups of Data
  • Creating Groups of Data: The GROUP BY Clause Syntax
  • Using the GROUP BY Clause
  • Grouping by More Than One Column
  • Using the GROUP BY Clause on Multiple Columns
  • Illegal Queries Using Group Functions
  • Excluding Group Results
  • Excluding Group Results: The HAVING Clause
  • Using the HAVING Clause
  • Nesting Group Functions
  Module 6: Subqueries
  • Objectives
  • Using a Subquery to Solve a Problem
  • Subquery Syntax
  • Using a Subquery
  • Guidelines for Using Subqueries
  • Types of Subqueries
  • Single-Row Subqueries
  • Executing Single-Row Subqueries
  • Using Group Functions in a Subquery
  • The HAVING Clause with Subqueries
  • What is Wrong with this Statement?
  • Will this Statement Return Rows?
  • Multiple-Row Subqueries
  • Using the ANY Operator in Multiple-Row Subqueries
  • Using the ALL Operator in Multiple-Row Subqueries
  • Null Values in a Subquery
  Module 7: . Manipulating Data
  • Data Manipulation Language
  • Adding a New Row to a Table
  • The INSERT Statement Syntax 8-5
  • Inserting New Rows
  • Inserting Rows with Null Values
  • Inserting Special Values
  • Inserting Specific Date Values
  • Creating a Script
  • Copying Rows from Another Table
  • Changing Data in a Table
  • The UPDATE Statement Syntax
  • Updating Rows in a Table
  • Updating Two Columns with a Subquery
  • Updating Rows Based on Another Table
  • Updating Rows: Integrity Constraint Error
  • Removing a Row from a Table
  • The DELETE Statement
  • Deleting Rows from a Table
  • Deleting Rows Based on Another Table
  • Deleting Rows: Integrity Constraint Error
  • Using a Subquery in an INSERT Statement
  • Using the WITH CHECK OPTION Keyword on DML Statements
  • Overview of the Explicit Default Feature
  • Using Explicit Default Values
  • The MERGE Statement
  • The MERGE Statement Syntax
  • Merging Rows
  • Database Transactions
  • Advantages of COMMIT and ROLLBACK Statements
  • Controlling Transactions
  • Rolling Back Changes to a Marker
  • Implicit Transaction Processing
  • State of the Data Before COMMIT or ROLLBACK
  • State of the Data after COMMIT
  • Committing Data
  • State of the Data After ROLLBACK
  • Statement-Level Rollback
  • Read Consistency
  • Implementation of Read Consistency
  • Locking
  • Implicit Locking
  • Read Consistency Example
  Module 8: Creating and Managing Tables
  • Database Objects
  • Naming Rules
  • The CREATE TABLE Statement
  • Referencing Another User?s Tables
  • The DEFAULT Option
  • Creating Tables
  • Tables in the Oracle Database
  • Querying the Data Dictionary 9-10
  • Data Types
  • DateTime Data Types
  • TIMESTAMP WITH TIME ZONE Data Type
  • TIMESTAMP WITH LOCAL TIME Data Type
  • INTERVAL YEAR TO MONTH Data Type
  • INTERVAL DAY TO SECOND Data Type
  • Creating a Table by Using a Subquery Syntax
  • Creating a Table by Using a Subquery
  • The ALTER TABLE Statement
  • Adding a Column
  • Modifying a Column
  • Dropping a Column
  • The SET UNUSED Option
  • Dropping a Table
  • Changing the Name of an Object
  • Truncating a Table
  • Adding Comments to a Table
  Module 9: Including Constraints
  • What are Constraints?
  • Constraint Guidelines
  • Defining Constraints
  • The NOT NULL Constraint
  • The UNIQUE Constraint
  • The PRIMARY KEY Constraint
  • The FOREIGN KEY Constraint
  • FOREIGN KEY Constraint Keywords
  • The CHECK Constraint
  • Adding a Constraint Syntax
  • Adding a Constraint
  • Dropping a Constraint
  • Disabling Constraints
  • Enabling Constraints
  • Cascading Constraints
  • Viewing Constraints
  • Viewing the Columns Associated with Constraints
  Module 10: Creating Views
  • Database Objects
  • What is a View?
  • Why use Views?
  • Simple Views and Complex Views
  • Creating a View
  • Retrieving Data from a View
  • Querying a View
  • Modifying a View
  • Creating a Complex View
  • Rules for Performing DML Operations on a View
  • Using the WITH CHECK OPTION Clause
  • Denying DML Operations
  Module 11: Other Database Objects
  • Database Objects
  • What is a Sequence?
  • The CREATE SEQUENCE Statement Syntax
  • Creating a Sequence
  • Confirming Sequences
  • NEXTVAL and CURRVAL Pseudocolumns
  • Using a Sequence
  • Modifying a Sequence
  • Guidelines for Modifying a Sequence
  • Removing a Sequence
  • What is an Index?
  • How Are Indexes Created?
  • Creating an Index
  • When to Create an Index
  • When Not to Create an Index
  • Confirming Indexes
  • Function-Based Indexes
  • Removing an Index
  • Creating and Removing Synonyms
  Module 12: Controlling User Access
  • Objectives
  • Controlling User Access
  • Privileges
  • System Privileges
  • Creating Users
  • User System Privileges
  • Granting System Privileges
  • What is a Role?
  • Creating and Granting Privileges to a Role
  • Changing Your Password
  • Object Privileges
  • Granting Object Privileges
  • Using the WITH GRANT OPTION and PUBLIC Keywords
  • Confirming Privileges Granted
  • How to Revoke Object Privileges
  • Revoking Object Privileges
  • Database Links
  Module 13: SQL Workshop
  • Workshop Overview
  Module 14: . Using SET Operators
  • The SET Operators
  • Tables Used in This Lesson
  • The UNION Operator
  • Using the UNION Operator
  • The UNION ALL Operator
  • Using the UNION ALL Operator
  • The INTERSECT Operator
  • Using the INTERSECT Operator
  • The MINUS Operator
  • SET Operator Guidelines
  • The Oracle Server and SET Operators
  • Matching the SELECT Statements
  • Controlling the Order of Rows
  Module 15: Enhancements to the GROUP BY Clause
  • Review of Group Functions
  • Review of the GROUP BY Clause
  • Review of the HAVING Clause
  • GROUP BY with ROLLUP and CUBE Operators
  • ROLLUP Operator
  • ROLLUP Operator Example
  • CUBE Operator
  • CUBE Operator: Example
  • GROUPING Function
  • GROUPING Function: Example
  • GROUPING SETS
  • GROUPING SETS: Example
  • Composite Columns
  • Composite Columns: Example
  • Concatenated Groupings
  • Concatenated Groupings Example
  Module 16: Advanced Subqueries
  • What Is a Subquery?
  • Subqueries
  • Using a Subquery
  • Multiple-Column Subqueries
  • Column Comparisons
  • Pairwise Comparison Subquery
  • Nonpairwise Comparison Subquery
  • Using a Subquery in the FROM Clause
  • Scalar Subquery Expressions
  • Scalar Subqueries: Examples
  • Correlated Subqueries
  • Using Correlated Subqueries
  • Using the EXISTS Operator
  • Using the NOT EXISTS Operator
  • Correlated UPDATE
  • Correlated DELETE
  • The WITH Clause
  • WITH Clause: Example
  • Hierarchical Retrieval
  • Sample Data from the EMPLOYEES Table
  • Natural Tree Structure
  Module 17: Hierarchical Queries
  • Walking the Tree
  • Walking the Tree: From the Bottom Up
  • Walking the Tree: From the Top Down
  • Ranking Rows with the LEVEL Pseudocolumn
  • Formatting Hierarchical Reports Using LEVEL and LPAD
  • Pruning Branches
  Module 18: Extensions to DML and DDL Statements
  • Review of the INSERT Statement
  • Review of the UPDATE Statement
  • Overview of Multitable INSERT Statements
  • Overview of Multitable INSERT Statements
  • Types of Multitable INSERT Statements
  • Multitable INSERT Statements
  • Unconditional INSERT ALL
  • Conditional INSERT ALL
  • Conditional FIRST INSERT
  • Pivoting INSERT
  • External Tables
  • Creating an External Table
  • Example of Creating an External Table
  • Querying External Tables
  • CREATE INDEX with CREATE TABLE Statement
  Module 19: Creating and Running PL/SQL Code
  • SQL*Plus
  • Performing Essential PL/SQL Tasks
  • Calling PL/SQL from Other Languages
  • Language Fundamentals
  • PL/SQL Block Structure
  • The PL/SQL Character Set
  • Identifiers
  • Literals
  • The Semicolon Delimiter
  • Comments
  • The PRAGMA Keyword
  • Labels
  Module 20: Loop Basics
  • The Simple Loop
  • The WHILE Loop
  • The Numeric FOR Loop
  • The Cursor FOR Loop
  • Loop Labels
  • Tips for Iterative Processing
  Module 21: Exception Handlers
  • Exception-Handling Concepts and Terminology
  • Defining Exceptions
  • Raising Exceptions
  • Handling Exceptions
  • Building an Effective Error Management Architecture
  • Making the Most of PL/SQL Error Management
  Module 22 : Strings
  • String Datatypes
  • Working with Strings
  • String Function Quick Reference
  Module 23: Numbers
  • Numeric Datatypes
  • Number Conversions
  • Numeric Functions
  Module 24: Records
  • Records in PL/SQL
  Module 25: Collections
  • Collections Overview
  • Collection Methods (Built-Ins)
  • Working with Collections
  • Nested Table Multiset Operations
  Module 26: Miscellaneous Datatypes
  • The BOOLEAN Datatype
  • The RAW Datatype
  • The UROWID and ROWID Datatypes
  • The LOB Datatypes
  • Working with LOBs
  • Predefined Object Types
  Module 27: Data Retrieval
  • Cursor Basics
  • Working with Implicit Cursors
  • Working with Explicit Cursors
  • BULK COLLECT
  • SELECT ... FOR UPDATE
  • Cursor Variables and REF CURSORs
  • Cursor Expressions
  Module 28: Procedures, Functions, and Parameters
  • Procedures
  • Functions
  • Parameters
  • Local Modules
  • Module Overloading
  • Forward Declarations
  • Advanced Topics
  Module 29: Packages
  • Why Packages?
  • Rules for Building Packages
  • Rules for Calling Packaged Elements
  • Working with Package Data
  • When to Use Packages
  • Packages and Object Types
  Module 30: Triggers
  • DML Triggers
  • DDL Triggers
  • Database Event Triggers
  • INSTEAD OF Triggers
  • AFTER SUSPEND Triggers
  • Maintaining Triggers
  Module 31: Managing PL/SQL Code
  • Managing Code in the Database
  • Using Native Compilation
  • Using the Optimizing Compiler and Compile-Time Warnings
  • Conditional Compilation
  • Testing PL/SQL Programs
  • Debugging PL/SQL Programs
  • Tuning PL/SQL Programs
  • Protecting Stored Code
  Module 32: I/O and PL/SQL
  • Displaying Information
  • Reading and Writing Files
  • Sending Email
  • Working with Web-Based Data (HTTP)
  • Other Types of I/O Available in PL/SQL Oracle Apps DBA Course Syllabus
    Module 1: Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture
    • Introduction to Oracle E-Business Suite 11i, R12.1.3/12.2.3
    • Oracle E-Business Suite 11i, R12.1.3/12.2.3 Architecture
    • Oracle E-Business Suite 11i,
    • 1.3/12.2.3 Multi-Tier Architecture
    • Desktop Tier
    • Application Tier
    • Database Tier
    • Oracle Homes Architecture
    • Oracle E-Business Suite Technology Layer
    Module 2: Installation
    • Single Node Installation (12.1 and 12.2)
    • Multi-Node Installation (12.1 and 12.2).
    • Context File and Interpretation.
    Module 3: File System
    • Oracle Applications Technology
    • Oracle Applications Environment Files and Server Process Scripts
    • Oracle Applications Entire File System
    • The Applications and Database Context Files
    Module 4: AD Utilities
    • What are the AD Utilities?
    • AD Administration
    • Special Utilities
    • Context Editing
    • Reporting Utilities
    • Configuration Utilities
    Module 5: Concurrent Managers
    • Managing Concurrent Programs and Reports and Output Post processor.
    • Administering Concurrent Managers
    • Managing Profile Options
    • Incorporating a Custom Program
    • Scheduling requests and Request Sets
    Module 6: Patching
    • Patch Types, Terminology, and Components
    • Patch Creation and Patching Order
    • Patching Utilities
    • Introduction to Online Patching
    • Architectural Changes to Support Online Patching
    • Database Implementation
    • Editioning Views and the Application Data Model
    • Phases of the Online Patching Cycle
    Module 7: Running the AD Online Patching Utility
    • AD Online Patching Utility
    • Running the adop Utility
    • adop Commands
    • Executing the Patching Cycle
    • Status of a Patching Cycle
    • Patching in Multi-Node Environments
    • adop Remote Invocation
    • Hotpatch Mode
    Module 8: AutoConfig and Configuration Changes
    • Reduced Role for AutoConfig
    • Configuration Tools
    • New AutoConfig Tools for System Configuration
    • Service Groups and Services in Release R12.1.3/12.2.3
    • AutoConfig Managed Service Groups and Services
    • Managing Oracle HTTP Server Configurations
    • Web Applications
    • Summary of Configuration Changes
    • Autoconfig Template and Driver files Concepts
    Module 9: Cloning
    • Rapidclone Concepts
    • Cloning From Single node to Single node
    • Cloning From Multi-Node to Multi-Node
    • Cloning From Multi-Node to Single-Node
    • Database Refresh
    • 2.X and R12.1.X key changes
    • Post-Clone Procedures
    Module 10: Security
    • Creating Users
    • Assigning Responsibilities
    • FNDCPASS Concepts
    • Changing User Passwords using FNDCPASS
    Module 11: Workflow
    • Workflow Configuration
    • Workflow Troubleshooting and Debugging
    Module 12: System Administration
    • Creating Users
    • Assigning Responsibilities
    • Setting Up Printers
    • Changing Profile Options.
    • XML Publisher and Administration in DBA Perspective.
    • Code Migrations and awareness on Migration tools.
    • Key roles in Support for APPS DBA.
    • OAF Migrations
    Module 13: Troubleshooting & Performance Tuning
    • User connectivity issues Troubleshooting
    • Apache Troubleshooting
    • Jserv Troubleshooting
    • OC4J Troubleshooting
    • Forms & Concurrent Processing Troubleshooting
    • Autoconfig related issues Troubleshooting
    • Long-Running Jobs Troubleshooting
    • Java Memory Settings and Tuning
    • Troubleshooting Cloning Issues
    • Apps Health Monitoring
    • Certification matrix / CPU patchig for Applications and DB.
    • Raising DB and Apptier monitoring
    Module 14: Oracle Applications Advanced Topics
    • Creating Custom Product Top’s
    • Creating Custom Concurrent Managers
    • Weblogic Installation
    • Weblogc Domain Creation
    • Weblogic Administration
    • RAC DB and Oracle Applications using effectively.
    Oracle Dataguard Course Syllabus
    Module 1 : Introduction to Oracle Data Guard
    • Describe the basic components of Oracle Data Guard
    • Explain the differences between physical and logical standby databases
    • Explain the benefits of implementing Oracle Data Guard
    Module 2 : Creating a Physical Standby Database by Using Enterprise Manager Cloud Control
    • Create a Data Guard broker configuration
    • Create a physical standby database
    • Verify a Data Guard configuration
    • Edit database properties related to Data Guard
    • Test a Data Guard configuration
    Module 3 : Oracle Net Services in a Data Guard Environment
    • Understand the basics of Oracle Net Services
    • Configure client connectivity in a Data Guard configuration
    • Implement Data Guard best practice solutions in networking setup
    Module 4 : Creating a Physical Standby Database by Using SQL and RMAN Commands
    • Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition
    • Create a physical standby database by using the
    Module 5 : Using Oracle Active Data Guard
    • Use real-time query to access data on a physical standby database
    • Enable RMAN block change tracking for a physical standby database
    • Use Far Sync to extend zero data loss protection for intercontinental configurations
    Module 6 : Creating and Managing a Snapshot Standby Database
    • Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database
    • Convert a snapshot standby database back to a physical standby database
    Module 7 : Creating a Logical Standby Database
    • Determine when to create a logical standby database
    • Create a logical standby database
    • Manage SQL Apply filtering
    Module 8 : Oracle Data Guard Broker: Overview
    • The Data Guard broker architecture
    • Data Guard broker components
    • Benefits of the Data Guard broker
    • Data Guard broker configurations
    • How to use Enterprise Manager to manage your Data Guard configuration
    • How to invoke DGMGRL to manage your Data Guard configuration
    Module 9 : Creating a Data Guard Broker Configuration
    • Create a Data Guard broker configuration
    • Manage the Data Guard broker configuration
    Module 10 : Monitoring a Data Guard Broker Configuration
    • Use Enterprise Manager Cloud Control to monitor the configuration
    • Use DGMGRL to monitor the configuration
    • Use SQL to monitor the configuration
    Module 11 : Configuring Data Protection Modes
    • Describe the data protection modes
    • Change the data protection mode of your configuration
    • Using Enterprise Manager Cloud Control
    • Using DGMGRL
    • Using SQL
    Moudle 12 : Performing Role Transitions
    • Explain the database roles
    • Perform a switchover
    • Perform a failover
    Module 13 : Using Flashback Database in a Data Guard Configuration
    • Explain the advantages of using Flashback Database in a Data Guard configuration
    • Configure Flashback Database
    Module 14 : Enabling Fast-Start Failover
    • Configure fast-start failover
    • View information about the fast-start failover configuration
    • Manage the observer
    • Perform role changes in a fast-start failover configuration
    • Manually reinstate the primary database
    Module 15 : Backup and Recovery Considerations in an Oracle Data Guard Configuration
    • Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
    • Offload backups to a physical standby database
    • Recover your primary database by using a file from the physical standby database
    Module 16 : Enhanced Client Connectivity in a Data Guard Environment
    • Configure client connectivity in a Data Guard configuration
    • Implement failover procedures to automatically redirect clients to a new primary database
    Module 17 : Patching and Upgrading Databases in a Data Guard Configuration
    • By using Standby-First Patch Apply technique
    • By using traditional upgrade methods
    • By performing rolling upgrades
    • By using the DBMS_ROLLING package with Active Data Guard
    Module 18 : Optimizing a Data Guard Configuration
    • Monitor configuration performance
    • Optimize redo transport for best performance
    • Optimize SQL Apply
    Module 19 : Oracle Database Exadata Cloud Service Overview
    • Describe the architecture and capabilities of Exadata Cloud Service
    • Compare and contrast between Exadata Cloud Service and an on-premise Exadata implementation
    PL/SQL New Features and Enhancements in Oracle Database 12c Release 1 (12.1)
    • Design PL/SQL packages and program units that execute efficiently
    • Write code to interface with external applications and the operating system
    • Create PL/SQL applications that use collections
    • Write and tune PL/SQL code effectively to maximize performance
    • Implement a virtual private database with fine-grained access control
    • Write code to interface with large objects and use SecureFile LOBs
    • Gain an understanding of the Oracle Database Exadata Express Cloud Service
    • Invoker Rights Functions Can Be Result-Cached
    • Libraries Defined Using Directory Objects and Credentials
    • New Predefined Inquiry Directives ($$PLSQL_UNIT_OWNER, $$PLSQL_UNIT_TYPE)
    • PLSQL_DEBUG Compilation Parameter is Deprecated
    • PL/SQL Packages and Types Reference
    • Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1)
    • Control Invoker Rights Privileges for PL/SQL Code in Oracle Database 12c Release 1 (12.1) (INHERIT [ANY] PRIVILEGES)
    • Control Invoker Rights Privileges in Views in Oracle Database 12c Release 1 (12.1) (BEQUEATH CURRENT_USER)
    • Edition-Based Redefinition Enhancements in Oracle Database 12c Release 1 (12.1)
    • Extended Data Types in Oracle Database 12c Release 1 (12.1)
    • Implicit Statement Results in Oracle Database 12c Release 1 (12.1) (DBMS_SQL.RETURN_RESULT and DBMS_SQL.GET_NEXT_RESULT)
    • Invisible Columns in Oracle Database 12c Release 1 (12.1)
    • Multitenant : Database Triggers on Pluggable Databases (PDBs) in Oracle 12c Release 1 (12.1)
    • WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1)
    • PL/SQL-to-SQL Interface Enhancements for PL/SQL-Only Data Types in Oracle Database 12c Release 1 (12.1)
    • PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1)
    • Using the TABLE Operator with Locally Defined Types in PL/SQL
    • UTL_CALL_STACK : Get Detailed Information About the Currently Running Subprogram in Oracle Database 12c Release 1 (12.1)