3.3 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.
- Creating a Table
Create a table using Object Browser. - Viewing a Table
Select a table from the Object Tree and access tabs in the Object Detail View. - Editing Table Columns
Select a table from the Object Tree and click the Columns tab. - Editing Table Data
Select a table from the Object Tree and click the Data tab. - Dropping a Table
Select a table from the Object Tree, click the Columns tab, and select Drop Table from the More menu. - Creating an Application from a Table
Select a table from the Object Tree, click the Columns tab, and select Create App from the More menu. - Analyzing Statistics of a Table
Select a table from the Object Tree and click the Statistics tab to examine various metrics of a table. - Viewing Sample Queries for a Table
Select a table from the Object Tree and click the Sample Queries tab to view sample queries.
See Also:
- Tables and Table Clusters in Oracle Database Concepts for an introduction to schema objects and discusses tables
- Managing Tables in Oracle APEX Administration Guide
Parent topic: Managing Database Objects with Object Browser
3.3.1 Creating a Table
Create a table using Object Browser.
To create a table:
See Also:
- Using the Table Finder in Oracle APEX App Builder User’s Guide
- Overview of Tables in Oracle Database Concepts for information about tables
Parent topic: Managing Tables
3.3.2 Viewing a Table
Select a table from the Object Tree and access tabs in the Object Detail View.
To browse a table:
- In Object Browser, Object Tree, expand Tables and select a table.
- The Object Detail View appears and displays the following tabs:
- Columns - Displays the column name,
data type, nullable status, default value, primary key, comments, and
identify. Most commonly used actions display as buttons. Available actions
include:
- Add Column
- Modify Column
- Rename Column
- Drop Column
- Refresh
- More - Less commonly used
actions are accessible from the More menu.
Available actions include:
- Rename Table
- Copy Table
- Drop Table
- Truncate Table
- Table Comment
- Create Lookup Table
- Create App
- UI Defaults
- Data - Displays data in the current table. Available actions include:
- Insert Row - Insert a row in the table.
- Columns - Configure the columns to display.
- Filter - Create a filter by selecting a column, operation, and value.
- Count Rows - Displays the number of rows in the current table.
- Load Data - Use the Load Data Wizard to upload a file or copy and paste CSV data.
- Download - Download an XLSX file.
- Refresh - Refresh the current view.
- Indexes - Displays indexes associated with this
table. Available actions include:
- Create
- Drop
- Refresh
- Constraints - Displays a list of constraints for
the current table. Available actions include:
- Create
- Drop
- Enable
- Disable
- Refresh
- Grants - Details of grants for the
current table, including privilege, grantee, grantable, grantor, and object
name. Available actions include:
- Grant
- Revoke
- Refresh
- Statistics - Displays collected statistics about the current table and columns. Table statistics include the number of rows and blocks, the average row length, and the data was last analyzed. Available actions include:
- Gather Statistics
- Refresh
- Triggers - Displays a list of
triggers associated with the current table. To view trigger details, click
the trigger name. Available actions include:
- Create
- Drop
- Enable
- Disable
- Refresh
- Dependencies - Displays objects that
use (or depend) on the current table and objects the table depends on. To
link to an object, click the object name. Available actions include:
- Refresh
- DDL - Displays the DDL necessary to re-create this table, including keys, indexes, triggers, table and column comments, and table definition. Edit the code using a fully functional Code Editor. Available actions include:
- Download
- Refresh
Tip:
To learn more about the Code Editor, see Code Editor in Object Browser. - Sample Queries - Displays sample
queries for using the table. Includes Copy and Run capability. Available
actions include:
- Refresh
- Columns - Displays the column name,
data type, nullable status, default value, primary key, comments, and
identify. Most commonly used actions display as buttons. Available actions
include:
Parent topic: Managing Tables
3.3.3 Editing Table Columns
Select a table from the Object Tree and click the Columns tab.
To edit table columns:
See Also:
Parent topic: Managing Tables
3.3.4 Editing Table Data
Select a table from the Object Tree and click the Data tab.
To edit table data:
Parent topic: Managing Tables
3.3.5 Dropping a Table
Select a table from the Object Tree, click the Columns tab, and select Drop Table from the More menu.
To drop a table:
See Also:
Parent topic: Managing Tables
3.3.6 Creating an Application from a Table
Select a table from the Object Tree, click the Columns tab, and select Create App from the More menu.
APEX Data Dictionary analyzes the table data with DBMS_STATS
and adds the following pages:
- Chart page, if chart recommendation was computed
- Calendar page, if any date or timestamp column type exists
- Interactive report and form page
- Dashboard with charts with columns for charting (these dashboard charts automatically include links to the interactive report page)
- Faceted search page (if valid facets are found)
To create an application from a table in Object Browser:
Note:
If table Data Dictionary Cache is out of sync with the database table information due to making changes to the table (such as modifications to the table structure or column names), Create Application Wizard may raise an error. To avoid the error, refresh the Data Dictionary Cache.
See Also:
- Refreshing the Data Dictionary Cache in Oracle APEX Administration Guide
- Creating Applications in Oracle APEX App Builder User’s Guide
Parent topic: Managing Tables
3.3.7 Analyzing Statistics of a Table
Select a table from the Object Tree and click the Statistics tab to examine various metrics of a table.
To view the statistics of a table:
Parent topic: Managing Tables
3.3.8 Viewing Sample Queries for a Table
Select a table from the Object Tree and click the Sample Queries tab to view sample queries.
To view sample queries:
Parent topic: Managing Tables