ALL_TABLE_VIRTUAL_COLUMNS
ALL_TABLE_VIRTUAL_COLUMNS describes virtual columns in tables accessible to the current user.
Related Views
-
DBA_TABLE_VIRTUAL_COLUMNSdescribes virtual columns in all tables in the database. -
USER_TABLE_VIRTUAL_COLUMNSdescribes virtual columns in tables owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TABLE_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the table |
TABLE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the table |
VIRTUAL_COLUMN_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the virtual column |
VIRTUAL_COLUMN_EXPRESSION |
VARCHAR2(4000) |
Expression of the virtual column | |
COLUMN_ID |
NUMBER |
NOT NULL |
Sequence number of the column as created |
SEGMENT_COLUMN_ID |
NUMBER |
NOT NULL |
Sequence number of the column in the segment |
INTERNAL_COLUMN_ID |
NUMBER |
NOT NULL |
Internal sequence number of the column |
Note: This view is available starting with Oracle AI Database 26ai.
See Also: