Creating SQL Access objects

Create an SQL Access Object to execute adhoc queries against a database.

  1. Select File | New | SQL Access from the main menu. The SQL Access editor appears.
    Note: If you select the Package in which the SQL Access object should reside before creating it, some parameters are automatically populated in the New SQL Access window.
  2. Provide the Source folder, Package, and Name.
  3. Click Finish. An editor appears.
    Note: You can also use the Wizard to create this object. Click New to select the object.