3 Managing Database Objects with Object Browser
Object Browser enables developers to browse, create, and edit objects in the Oracle Database.
Oracle APEX 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. - Understanding Object Browser
Use Object Browser to create, browse, and edit database objects in your workspace. - Managing Tables
A table is a unit of data storage in an Oracle database, containing rows and columns. Use Object Browser to create, view, edit, or drop tables. - Managing Views
A view is a logical representation of another table or combination of tables. Use Object Browser to create, view, edit, download, compile, and drop views. - Managing Indexes
An index is an optional structure associated with tables and clusters. Use Object Browser to create, view, or drop an index. - Managing Sequences
A sequence generates a serial list of unique numbers for numeric columns of a database table. Use Object Browser to create, view, or drop a sequence. - Managing Types
A type is a user-specified object or collection definition. Use Object Browser to create, view, or drop a type. - Managing Packages
A package is a database object that groups logically related PL/SQL types, items, functions and procedures. Use Object Browser to view, create, edit, download, and drop packages. - Managing Procedures
A procedure is a subprogram that performs a specific action. 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, view, edit, compile, download, and drop functions. - Managing Triggers
A database trigger is a stored subprogram associated with a database table, view, or event. You can use Object Browser to create, view, edit, compile, download, drop, and disable or enable a trigger. - Managing Database Links
A database link is a schema object in one database that enables you to access objects in another database. Use Object Browser to create, browse, or drop a database link. - Managing Materialized Views
A materialized view is a query result that is stored or materialized in advance as a schema object. Use Object Browser to view, or drop materialized views. - Managing Synonyms
A synonym is an alias for a schema object. Use Object Browser to create, view and drop a synonym. - Managing SODA Collections
Use Object Browser to load data to a SODA collection as JSON, TXT, or ZIP files.