3.134 ALL_BLOCKCHAIN_TABLE_HASH_COL_ORDER

ALL_BLOCKCHAIN_TABLE_HASH_COL_ORDER displays information about columns used to compute the cryptographic hash in the blockchain tables accessible to the current user.

Related Views

  • DBA_BLOCKCHAIN_TABLE_HASH_COL_ORDER displays information about columns used to compute the cryptographic hash in all blockchain tables in the database.

  • USER_BLOCKCHAIN_TABLE_HASH_COL_ORDER displays information about columns used to compute the cryptographic hash in the blockchain tables owned by the current user. This view does not display the SCHEMA_NAME column.

Column Datatype NULL Description

SCHEMA_NAME

VARCHAR2(128)

NOT NULL

Name of the schema containing the blockchain table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Blockchain table name

EPOCH_NUMBER

NUMBER

Epoch number

COLUMN_NAME

VARCHAR2(128)

Name of the user column or hidden column

COLUMN_POSITION

NUMBER

Order in which the column is hashed

INTERNAL_COLUMN_ID

NUMBER

Internal column ID

COLUMN_DATA_TYPE

VARCHAR2(106)

Data type of the user column or hidden column

Note:

This view is available starting with Oracle Database 23ai.

See Also: