A.29 USER_VIEWS

USER_VIEWS data dictionary for Oracle Database Gateway for DRDA.

The USER_VIEWS view contains text of views owned by the user.

Column name Description

VIEW_NAME

Name of the view

TEXT_LENGTH

Length of the view text

TEXT

First line of the view text

TYPE_TEXT_LENGTH

Length of the type clause of the typed view

TYPE_TEXT

Type clause of the typed view

OID_TEXT_LENGTH

Length of the WITH OID clause of the typed view

OID_TEXT

WITH OID clause of the typed view

VIEW_TYPE_OWNER

Owner of the type of the view, if the view is a typed view

VIEW_TYPE

Type of the view, if the view is a typed view

SUPERVIEW_NAME

N/A