Displaying Views - wykład

Displaying Views
You can use SQL Developer to list the views in a specified schema. You can also
display the view definitions.
To display views:
1. In the Connections navigator, navigate to the Views node for the schema that
includes the view you want to display.
If the view is in your own schema, navigate to the Views node in your schema.
If the view you want to display is in another user's schema, navigate to the Other
Users node, expand it, find the name of the schema the view is in, and navigate to
the Views node.
Examples of schema names include SYS and HR.
2. Open the Views node.
The list of views in the schema appears.
3. Click the name of the view that you want to display.
A tab with the view name appears in the object pane, with the Columns subtab
displayed. You can view the view definition on this tab.
... zobacz całą notatkę