Create an SQL Access Object to execute adhoc queries against a database.
-
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.
-
Provide the Source folder, Package, and Name.
-
Click Finish. An editor appears.
Note: You can also use the Wizard to create this object. Click
New
to select the
object.