2.3 Managing Tables
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.
- Creating a Table
Create a table using Object Browser. - Browsing a Table
Learn how to view different reports about a table. - Reports Available for Tables
Learn about alternative views available when viewing a table in Object Browser. - Editing a Table
Click the appropriate buttons on a table in Object Browser to edit a table. - Dropping a Table
Drop a table using Object Browser. - Creating an Application from a Table
Use the Create App button to quickly enter the Create Application Wizard based on the current table. - Analyzing Statistics of a Table
Use the Statistics tab to examine various metrics of a 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
2.3.1 Creating a Table
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
2.3.2 Browsing a Table
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
2.3.3 Reports Available for 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
2.3.4 Editing a Table
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
2.3.5 Dropping a Table
Drop a table using Object Browser.
To drop a table:
See Also:
Parent topic: Managing Tables
2.3.6 Creating an Application from a Table
Use the Create App button to quickly enter the Create Application Wizard based on the current table.
To create an application from a table in Object Browser:
- Select a table in Object Browser.
- Click Create App.
- On the confirmation page, click Create App.
See Also:
Oracle Application Express App Builder User’s Guide in the Oracle Application Express App Builder User’s Guide
Parent topic: Managing Tables
2.3.7 Analyzing Statistics of a Table
Use the Statistics tab to examine various metrics of a table.
To view the statistics of a selected table:
To refresh the displayed statistics:
Parent topic: Managing Tables