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_COLSdisplays information about row versioned columns in all blockchain tables in the database. -
USER_BLOCKCHAIN_ROW_VERSION_COLSdisplays 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 AI Database 26ai.