Viewing Object Reports

Utilities includes a variety of object reports to help you better manage the objects in your database.

Topics:

Table Reports

Use the Table reports to view specific details about the tables within your database.

To view the Table reports:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the Table Reports section, select the report you want to view:

    • Table Columns

    • Table Comments

    • Table Constraints

    • Table Statistics

    • Table Storage Sizes

  5. To filter a report, enter search criteria in the fields provided or make selections from the lists, and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

  6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

Security Reports

Use the Security reports to view object or column privileges granted on database objects owned by other schemas. You can also use these reports to view database role and system privileges.

To view the Security reports:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the Security Reports section, click the report you want to view:

    • Object Grants - View the privileges for an existing schema and also understand what privileges have been granted from the selected schema to other schemas.

    • Column Privileges - View the privileges for columns within your schema and also understand what privileges have been granted from the selected schema to other schemas.

    • Role Privileges - View the database roles that have been granted to a selected schema. Roles are collections of various privileges.

    • System Privileges - View the database privileges that have been granted to a selected schema.

  5. To filter a report, enter search criteria in the fields provided or make selections from the lists, and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

  6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

PL/SQL Reports

Use the PL/SQL reports to view program unit arguments or unit line counts and also to search PL/SQL source code.

Topics:

Program Unit Arguments

Use the Program Unit Arguments report to view package input and output parameters.

To view the PL/SQL Unit Arguments report:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the PL/SQL Reports section, click Program Unit Arguments.

  5. To filter a report, enter search criteria in the fields provided or make selections from the lists, and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

  6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

Unit Line Counts

Use the Unit Line Counts report to view the number of lines of code for each object. Use this report to identify larger PL/SQL program units.

To view the Unit Line Counts report:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the PL/SQL Reports section, click Unit Line Counts.

  5. To filter the report, enter an object name and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

  6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

Search PL/SQL Source Code

Use the Search PL/SQL Source code page to search the text within your PL/SQL code. Use this report to find references to tables or functions you might be thinking of deleting. You can also use this page to locate code when you can only recall a code snippet.

To search for PL/SQL source code:

  1. On the Workspace home page, click the Utilities icon.

  2. Click Object Reports.

    The Object Reports page appears.

  3. In the PL/SQL Reports section, click Search PL/SQL Source Code.

  4. To filter the report:

    1. In From/To Line, enter the range of lines you want to search.

    2. Click Set.

    3. To filter the report, enter an object name and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details

  5. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

Exception Reports

Use the Exception Reports to view unindexed foreign keys and tables without primary keys, indexes, or triggers.

To view Exception reports:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the Exception Reports section, click the report you want to view.

    • Tables without Primary Keys

    • Tables without Indexes

    • Unindexed Foreign Keys

    • Tables without Triggers

  5. To filter the report, enter a table name and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

  6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

All Object Reports

Use the All Object reports to view objects for the selected schema.

To view the All Object reports:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the All Object Reports section, select the report you want to view:

    • All Objects - List all objects in the current schema. Displays creation date and when the last DDL (data definition language) was performed.

    • Invalid Objects - View all invalid objects in the database by object type.

    • Object Creation Calendar - View all objects in a calendar format based on the date each database object was created.

    • Object Counts by Type - View the number of database objects by type for the selected schema.

    • Data Dictionary - View the data dictionary for this database.

      An Oracle data dictionary is a set of tables and views used as a read-only reference about the database. For example, a data dictionary stores information about both the logical and physical structure of the database.

      A data dictionary also stores information about valid Oracle database users, integrity constraints for tables in the database, and the amount of space allocated for a schema object and the amount being used.

  5. For All reports, you can filter the report:

    1. Select an object type.

    2. Enter an object name.

    3. Click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details

  6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

See Also:

Oracle Database Concepts for information about the data dictionary