4.139 ALL_TABLE_VIRTUAL_COLUMNS

ALL_TABLE_VIRTUAL_COLUMNS describes virtual columns in tables accessible to the current user.

Related Views

  • DBA_TABLE_VIRTUAL_COLUMNS describes virtual columns in all tables in the database.

  • USER_TABLE_VIRTUAL_COLUMNS describes 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 Database 23ai.

See Also: