2 Managing Database Objects with Object Browser

Object Browser enables developers to browse, create, and edit objects in a database.

Oracle Application Express has many views defined to help you work with the underlying table structures. The views combine multiple base tables and use meaningful column names to minimize complexity and to be more intuitive to use.

• Accessing Object Browser
  Learn about how to access Object Browser.
• Object Browser
  The Object Browser page is divided into two panes - Object Selection pane and Detail pane.
• Searching for and Browsing Database Objects
  Filter the view by selecting an object type or entering a case insensitive search term.
• Searching For and Selecting Database Objects
  Search for and select database objects in Object Browser by selecting an object type from the Object list.
• Hiding the Object Selection Pane
  You can hide the Object Selection pane by selecting the Collapse control which displays on the right side of the Object Selection pane.
• Creating Database Objects
  You can create database objects using the Create Database Object Wizard.
• Managing Tables
  You can create, browse, edit, or drop tables as well as view different table reports.
• Managing Views
  A view is a logical representation of another table or combination of tables. You can create, browse, edit, download, compile, drop a view and view reports.
• Managing Indexes
  An index is an optional structure associated with tables and clusters. You can create, browse, drop an index and view reports.
• Managing Sequences
  A sequence generates a serial list of unique numbers for numeric columns of a database table. You can create, browse, drop, alter a sequence and view a report.
• Managing Types
  A type is a user-specified object or collection definition. You can create, browse, drop a type and view a report.
• Managing Packages
  A package is a database object that groups logically related PL/SQL types, items, functions and procedures. You can create, view, edit, compile, drop, download a package, and view a report.
• Managing Procedures
  A procedure is a subprogram that performs a specific action. You can use Object Browser to view, create, edit, download, and drop procedures.
• Managing Functions
  A function is a subprogram that can take parameters and return a single value. You can use Object Browser to create, browse, edit, compile, download, drop functions and view report.
• Managing Triggers
  A database trigger is a stored subprogram associated with a database table, view, or event. You can create, browse, edit, compile, download, drop, disable or enable a trigger and view report.
• Managing Database Links
  A database link is a schema object in one database that enables you to access objects in another database. You can create, browse, drop a database link and view report.
• Managing Materialized Views
  A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. You can create, browse, drop a materialized view and view report.
• Managing Synonyms
  A synonym is an alias for a schema object. You can create, view and drop a synonym.