By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ORA-00904: : invalid identifier
| TABLE_NAME | COLUMN_NAME | DATA_TYPE | DATA_TYPE_MOD | DATA_TYPE_OWNER | DATA_LENGTH | DATA_PRECISION | DATA_SCALE | NULLABLE | COLUMN_ID | DEFAULT_LENGTH | DATA_DEFAULT | NUM_DISTINCT | LOW_VALUE | HIGH_VALUE | DENSITY | NUM_NULLS | NUM_BUCKETS | LAST_ANALYZED | SAMPLE_SIZE | CHARACTER_SET_NAME | CHAR_COL_DECL_LENGTH | GLOBAL_STATS | USER_STATS | AVG_COL_LEN | CHAR_LENGTH | CHAR_USED | V80_FMT_IMAGE | DATA_UPGRADED | HISTOGRAM | DEFAULT_ON_NULL | IDENTITY_COLUMN | EVALUATION_EDITION | UNUSABLE_BEFORE | UNUSABLE_BEGINNING | COLLATION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BUILDING | ID | NUMBER | null | null | 22 | null | null | Y | 1 | null | null | null | 0x | 0x | null | null | null | null | null | null | null | NO | NO | null | 0 | null | NO | YES | NONE | NO | NO | null | null | null | null |
| BUILDING | DESCRIPTION | VARCHAR2 | null | null | 255 | null | null | N | 2 | null | null | null | 0x | 0x | null | null | null | null | null | CHAR_CS | 255 | NO | NO | null | 255 | B | NO | YES | NONE | NO | NO | null | null | null | USING_NLS_COMP |