3.230 ALL_IMMUTABLE_ROW_VERSION_COLS

ALL_IMMUTABLE_ROW_VERSION_COLS displays information about row versioned columns in the immutable tables accessible to the current user.

Related Views

• DBA_IMMUTABLE_ROW_VERSION_COLS displays information about row versioned columns in all immutable tables in the database.

• USER_IMMUTABLE_ROW_VERSION_COLS displays information about row versioned columns in the immutable tables owned by the current user.

Column	Datatype	NULL	Description
SCHEMA_NAME	VARCHAR2(128)	NOT NULL	Schema containing the immutable table
TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the immutable table
ROW_VERSION_NAME	VARCHAR2(128)	NOT NULL	Name of the row version
KEYCOL1_NAME	VARCHAR2(128)	NOT NULL	Name of version key column 1
KEYCOL2_NAME	VARCHAR2(128)		Name of version key column 2 Null if only one version key column is specified for the row version
KEYCOL3_NAME	VARCHAR2(128)		Name of version key column 3 Null if only one or two version key columns are specified for the row version

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_IMMUTABLE_ROW_VERSION_COLS"

• "USER_IMMUTABLE_ROW_VERSION_COLS"