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. - Managing Object Browser
Use Object Browser to review the database objects in your workspace. - 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.
See Also:
-
Oracle Application Express API Reference for details of the views defined