Per partecipare con profitto a questo corso è necessario che gli allievi possiedano i seguenti prerequisiti:

•  conoscenza dei linguaggi SQL e PL/SQL

• Invoker's Rights Functions Can Be Result-Cached
• More PL/SQL-Only Data Types Can Cross PL/SQL-to-SQL Interface
• ACCESSIBLE BY Clause
• FETCH FIRST Clause
• Can Grant Roles to PL/SQL Packages and Standalone Subprograms
• More Data Types Have Same Maximum Size in SQL and PL/SQL
• DATABASE Triggers on PDBs
• LIBRARY Can Be Defined as DIRECTORY Object and With CREDENTIAL
• Implicit Statement Results
• BEQUEATH CURRENT_USER Views
• INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES Privileges
• Invisible Columns
• Objects, Not Types, Are Editioned or Noneditioned
• PL/SQL Functions That Run Faster in SQL
• Predefined Inquiry Directives $$PLSQL_UNIT_OWNER and $$PLSQL_UNIT_TYPE
• Compilation Parameter PLSQL_DEBUG is Deprecated
• Row Limiting Clause for Top-N Queries in Oracle Database 12c
• SQL Query Row Limits and Offsets Oracle Database
• Truncate table Cascade