About the Workspace Home Page

When you log in to Oracle Application Express, the Workspace home page appears.

Description of the illustration workspace4.gif

Take a few minutes to explore the product. The following three large icons appear in the center of the page:

• Application Builder. Use Application Builder to assemble an HTML interface (or application) on top of database objects such as tables and procedures. Most exercises in this guide use Application Builder.

• SQL Workshop. Use the SQL Workshop to access tools to view and manage database objects. Click SQL Workshop to access the following database tools:

  • Object Browser. View, create, modify, browse, and drop database objects. Use the PL/SQL editor to edit and compile packages, procedures, functions, and triggers while taking advantage of error reporting.

  • SQL Commands. Run SQL commands and anonymous PL/SQL, scripts, and saved queries.

  • SQL Scripts. Create, edit, view, run, and delete script files. You can also upload and download scripts from your local file system.

  • Query Builder. Search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save queries with little or no SQL knowledge, using Query Builder's graphical user interface.

• Utilities. Import and export data from the database, generate DDL, view object reports, restore dropped database objects, and perform other tasks.

Note that your workspace and username appear in the lower left corner.

About the Administration List

An Administration list appears on the right side of the Workspace home page. Use the links to administer your application development environment.

If you have administrator or developer privileges, these links appear:

• Administration. Click this link to view a list of administrative tasks. If you are a developer, you have limited access to these features.

  • Manage Services. Click this link to manage session state, log files, preferences, and application models.

  • Manage Application Express Users. Click this link to manage Application Express user accounts as well as user groups.

  • Monitor Activity. Click this link to monitor page view and application changes.

• Change Password. Click this link to open a popup window where you can change your workspace password.

• About Application Express. Click this link to see version and configuration information for both Oracle Application Express and your database.

About the Migrations Link

Use the Migrations link to migrate a Microsoft Access application and generate an Oracle Application Express application from the retrieved objects.

About the Workspace Schemas List

The Workspace Schemas list displays the database schemas that are associated with, and therefore accessible to, this workspace.

About the Links List

The Links list contains links to resources to expand your knowledge of Oracle Application Express.

Description of the illustration gtst_reslinks.gif

• Oracle Technology Network opens the Oracle Application Express section of Oracle Technology Network. Use this page to access additional information and resources about using Oracle Application Express.

  
  

  Tip: Use this link to check for newer versions of Oracle Application Express, to download packaged applications you can use with Oracle Application Express, and to take advantage of sample code to accelerate your development process. For more information, see "Next Steps".

  
  

• Discussion Forum opens the Oracle Application Express Discussion Forum. This is an excellent resource for research and finding answers to questions or answering questions from other users.

• User's Guide opens an HTML-based online Help system. You can also access online Help by clicking the Help link in the upper right corner of any page in Oracle Application Express.