1 Getting Started with SQL Workshop
The SQL Workshop provides tools that enable you to view and manage database objects. Object Browser enables you to use a tree control to view object properties and create new objects. The SQL Commands tool enables you to enter ad-hoc SQL. Query Builder enables you to create join queries using drag and drop. SQL Scripts enables you to store and run scripts. The Data Workshop enables you to load and unload text, DDL, and spreadsheet data.
1.1 SQL Workshop Icons
You access SQL Workshop by clicking the SQL Workshop icon on the Workspace home page. The SQL Workshop home page appears.
Description of the illustration home_page.png
SQL Workshop home page features the following icons:
-
Object Browser. See "Managing Database Objects with Object Browser."
-
SQL Commands. See "Using SQL Commands."
-
SQL Scripts. See "Using SQL Scripts."
-
Utilities. See "Using Oracle Application Express Utilities."
-
RESTful Services. See "Using RESTful Services."
1.2 Selecting a Schema
A schema is a logical container for database objects. Use the Schema list on the right side of the SQL Workshop home page to select the default database schema for your SQL Workshop session. Only schemas assigned to your workspace display in the Schema list.
Description of the illustration select_schema.png