[Home] [Help] [Dependency Information]
Object Name: | USER_EDITIONING_VIEW_COLS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Relationship between columns of user's Editioning Views and the table columns to which they map
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VIEW_NAME | VARCHAR2 | (128) | Yes | Name of an Editioning View |
VIEW_COLUMN_ID | NUMBER | Yes | Column number within the Editioning View | |
VIEW_COLUMN_NAME | VARCHAR2 | (128) | Yes | The name of the column in the Editioning View |
TABLE_COLUMN_ID | NUMBER | Yes | Column number of a table column to which this EV column maps | |
TABLE_COLUMN_NAME | VARCHAR2 | (128) | Yes | Name of a table column to which this EV column maps |
Cut, paste (and edit) the following text to query this object:
SELECT VIEW_NAME
, VIEW_COLUMN_ID
, VIEW_COLUMN_NAME
, TABLE_COLUMN_ID
, TABLE_COLUMN_NAME
FROM SYS.USER_EDITIONING_VIEW_COLS;
|
|
|