Object Browser

The first module of the SQL workshop is the Object Browser. This module can be very useful and a productivity enhancer tool for both novice and experienced developers. It allows you to declaratively browse and manage the database objects within the schema(s) that is/are associated with the APEX workspace. In general, the Object Browser allows you to review and edit the structure of the database objects and their main features and attributes. It allows us to declaratively create new database objects, add new features to existing ones, and, of course, browse through stored data with the ability to Insert, Update, or Delete table records.

Exploring the database with the Object Browser

The following screenshot displays the upper-left-hand corner of the main Object Browser screen:

The select list field (displaying Tables in the example) allows us to choose the database object type we want to focus on. The Object Browser supports the following database objects: Tables, Views, Indexes...