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 in SQL Developer, 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.

    Note:

    You must have the necessary privileges to view other schemas and the objects in those schemas.

  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.

See Also:

"About Views"