Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors

Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisite
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration
120 minutes

Description
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.

Objective

Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors

  • identify the steps for trapping non-predefined exceptions in PL/SQL.
  • recognize the steps for trapping user-defined exceptions.
  • create an exception handler in a given scenario.
  • identify the steps for creating and invoking simple stored procedures and functions.
  • recognize the scope and capabilities of JDeveloper for developing and deploying Java applications and Web services.
  • recognize the steps for using cursor variables to pass query result sets, and for fetching rows from them.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.