<< Click to Display Table of Contents >>

Overview Dictionary Views

Top Previous Next

Overview Dictionary Views is the default sheet. It presents a list of all dictionary views as seen by the current schema:

Name of the dictionary view

Comments

Use the * / ALL_ / USER_ / DBA_ / V$ -/GV$- Tabs below the grid to show only dictionary views that match the appropriate prefix.

The context toolbar and the right mouse button popup menu allow the following operations:

Find

Search

Searches for a string within a member of the list of dictionary views.

CopySQL

 

SQL to clipboard

Generates a SELECT column_name, ..., column_name FROM dict_view statement with column information from the selected dictionary view and copies the statement to the clipboard.

 

Grid View

For more information, see object window