This system table lists all columns of virtual tables. It contains the information which are specific to virtual columns. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
Virtual columns are also listed in the table EXA_DBA_COLUMNS.
| Column Name | Description |
|---|---|
COLUMN_SCHEMA
|
Associated virtual schema |
COLUMN_TABLE
|
Associated virtual table |
COLUMN_NAME
|
Name of the virtual column |
COLUMN_OBJECT_ID
|
ID of the virtual column object |
ADAPTER_NOTES
|
The adapter can store additional information about the virtual column in this field |
