3.130 ALL_BLOCKCHAIN_ROW_VERSION_COLS

ALL_BLOCKCHAIN_ROW_VERSION_COLS displays information about row versioned columns in the blockchain tables accessible to the current user.

Related Views

  • DBA_BLOCKCHAIN_ROW_VERSION_COLS displays information about row versioned columns in all blockchain tables in the database.

  • USER_BLOCKCHAIN_ROW_VERSION_COLS displays information about row versioned columns in the blockchain tables owned by the current user.

Column Datatype NULL Description

SCHEMA_NAME

VARCHAR2(128)

NOT NULL

Schema containing the blockchain table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the blockchain table

ROW_VERSION_NAME

VARCHAR2(128)

NOT NULL

Name of the row version

USER_CHAIN

VARCHAR2(3)

Indicates whether row versioning with user chains is enabled for the blockchain table (YES) or not (NO)

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: