You can create, browse, edit, or drop tables as well as view different table reports.
A table is a unit of data storage in an Oracle database, containing rows and columns. When you view a table in Object Browser, a table description appears that describes each column in the table.
See Also:
Oracle Database Administrator’s Guide for information on managing tables
Oracle Database Concepts for conceptual information on tables types
Oracle Database SQL Language Reference for the syntax required to create and alter tables
Parent topic: Managing Database Objects with Object Browser
Create a table using Object Browser.
To create a table:
See Also:
"Using the Table Finder" in Oracle Application Express App Builder User’s Guide
"Overview of Tables" in Oracle Database Concepts for information about tables
Parent topic: Managing Tables
Learn how to view different reports about a table.
When you view a table in Object Browser, the table description appears. While viewing this description, you can add a column, modify a column, rename a column, drop a column, rename the table, copy the table, drop the table, truncate the table, or create a lookup table based upon a column in the current table. Additionally, you have access to other reports that offer related information including the table data, indexes, data model, constraints, grants, statistics, user interface defaults, triggers, dependencies, and SQL to create the selected table.
To view a table description:
See Also:
Parent topic: Managing Tables
Learn about alternative views available when viewing a table in Object Browser.
Table 2-1 describes all available reports for tables.
Table 2-1 Available Reports for Tables
View | Description |
---|---|
Table |
Displays details of the first 57 columns including the column name, data type, nullable status, default value, and primary key. While viewing table details you can add, modify, delete, or rename a column. Additionally, you can drop, rename, copy, or truncate the table only if the referencing table has no records and create a lookup table. To export the data as a comma-delimited file (.csv) file, click the Download link. To print the data in a portable document format (.pdf) file, click the Print link. Please note, this option must have a Report Server configured at the instance level. See "Configuring Report Printing" in Oracle Application Express Administration Guide. |
Data |
Displays a report of the data in the current table. Actions you can perform include:
|
Indexes |
Displays indexes associated with this table. Actions you can perform include Create and Drop. |
Model |
Displays a graphical representation of the selected table along with all related tables. Related tables are those that reference the current table in a foreign key and those tables referenced by foreign keys within the current table. You can position the cursor over an underlined table name to view the relationship between that table and the current table. Click an underlined table name to view the model of the related table. |
Constraints |
Displays a list of constraints for the current table. Actions you can perform include Create, Drop, Enable, and Disable. |
Grants |
Displays a list of grants on the current table, including the grantee, the privilege, and grant options. Actions you can perform in this view include Grant and Revoke. |
Statistics |
Displays collected statistics about the current table, including the number of rows and blocks, the average row length, sample size, when the data was last analyzed, and the compression status (enabled or disabled). Click Analyze to access the Analyze Table Wizard. |
UI Defaults |
Displays user interface defaults for forms and reports. User interface defaults enable developers to assign default user interface properties to a table, column, or view within a specified schema. Click Edit to edit defined user interface defaults. Click Create Defaults to initialize user interface defaults for tables that do not currently have user interface defaults defined. |
Triggers |
Displays a list of triggers associated with the current table. Actions you can perform include Create, Drop, Enable, and Disable. To view trigger details, click the trigger name. |
Dependencies |
Displays report showing objects referenced by this table, objects this table references, and synonyms for this table. |
SQL |
Displays the SQL necessary to re-create this table, including keys, indexes, triggers and table definition. |
See Also:
Parent topic: Managing Tables
Click the appropriate buttons on a table in Object Browser to edit a table.
While viewing a table description, you can edit it by clicking the buttons above the table description.
To edit a table:
See Also:
Parent topic: Managing Tables
Drop a table using Object Browser.
To drop a table:
See Also:
Parent topic: Managing Tables