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

System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisite
Previous programming experience and knowledge of SQL

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: Using 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.