5.12 Viewing Object Reports

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

• Viewing Table Reports
  Use the Table reports to view specific details about the tables within your database.
• Viewing 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.
• Viewing Exception Reports
  Use the Exception Reports to view unindexed foreign keys and tables without primary keys, indexes, or triggers.
• Viewing Security Reports
  Use the Security reports to view object or column privileges granted on database objects owned by other schemas.
• Viewing All Object Reports
  Use the All Object reports to view objects for the selected schema.

5.12.1 Viewing 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. Under Table Reports, select a report to view:

   • Table Columns

   • Table Comments

   • Table Constraints

   • Table Statistics

   • Table Storage Sizes

5. To filter a report, enter search criteria in the field provided and click Go.
6. To view reports for a different schema, select another schema from the Schema list.

See Also:

Customizing an Interactive Report Using the Actions Menuin Oracle APEX End User’s Guide

5.12.2 Viewing 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.

• Viewing Package Input and Output Parameters
  Use the Program Unit Arguments report to view package input and output parameters.
• Viewing the Number of Lines of Code for an Object
  Use the Unit Line Counts report to view the number of lines of code for each object.
• Searching PL/SQL Source Code
  Use the Search PL/SQL Source code page to search the text within your PL/SQL code.

See Also:

Customizing an Interactive Report Using the Actions Menu in Oracle APEX End User’s Guide

5.12.2.1 Viewing Package Input and Output Parameters

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. Under PL/SQL Reports, click Program Unit Arguments.
5. To filter a report, enter search criteria in the field provided and click Go.
6. To view reports for a different schema, select another schema from the Schema list.

5.12.2.2 Viewing the Number of Lines of Code for an Object

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. Under PL/SQL Reports, click Unit Line Counts.

   The PL/SQL Unit Line Counts report appears.

5. To view reports for a different schema, select another schema from the Schema list.

5.12.2.3 Searching 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. Under PL/SQL Reports, click Search PL/SQL Source Code.

4. To filter the report:

   1. In From Line and 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.

5. To view reports for a different schema, select another schema from the Schema list.

5.12.3 Viewing 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.
6. To view reports for a different schema, select another schema from the Schema list.

See Also:

Customizing an Interactive Report Using the Actions Menu in Oracle APEX End User’s Guide

5.12.4 Viewing 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. Under Security Reports, 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 field provided and click Go.
6. To view reports for a different schema, select another schema from the Schema list.

See Also:

Customizing an Interactive Report Using the Actions Menu in Oracle APEX End User’s Guide

5.12.5 Viewing 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. Under All Object Reports, select a report 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. To filter a report, enter search criteria in the field provided and click Go.
6. To view reports for a different schema, select another schema from the Schema list.

See Also:

• Customizing an Interactive Report Using the Actions Menu in Oracle APEX End User’s Guide

• Data Dictionary and Dynamic Performance Views in Oracle Database Conceptsfor information about the data dictionary