Getting Started with SQL and PL/SQL New Features

Overview/Description
To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies

Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Getting Started with SQL and PL/SQL New Features

recognize ways for using SQL*Plus commands to display the structure of a table and perform some editing and file management tasks.

recognize the steps for using SQL Developer and SQL Worksheet to connect to a database, browse and export database objects, and use SQL*Plus to enter and execute SQL and PL/SQL statements.

identify the steps for using SQL Developer to create reports and migrate to an Oracle Database 11g database.

recognize the steps for using Oracle Database 11g's new SQL and PL/SQL language functionality enhancements.

recognize the scope and uses of Data Change Notification (DCN) and lock enhancements.

use SQL and PL/SQL language functionality enhancements to connect to a database and create a report, examine dependency at the element level, and modify an exception handler.