Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
|---|---|---|---|---|---|
| COUNTRY_ID | CHAR(2 BYTE) | No | null | 1 | Primary key of countries table. |
| COUNTRY_NAME | VARCHAR2(40 BYTE) | Yes | null | 2 | Country name |
| REGION_ID | NUMBER | Yes | null | 3 | Region ID for the country. Foreign key to region_id column in the departments table. |
| CONSTRAINT_NAME | CONSTRAINT_TYPE | SEARCH_CONDITION | R_OWNER | R_TABLE_NAME | R_CONSTRAINT_NAME | DELETE_RULE | STATUS | DEFERRABLE | VALIDATED | GENERATED | BAD | RELY | LAST_CHANGE | INDEX_OWNER | INDEX_NAME | INVALID | VIEW_RELATED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COUNTR_REG_FK | Foreign_Key | null | HR | REGIONS | REG_ID_PK | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011/08/28 | null | null | null | null |
| COUNTRY_C_ID_PK | Primary_Key | null | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011/08/28 | null | COUNTRY_C_ID_PK | null | null |
| COUNTRY_ID_NN | Check | "COUNTRY_ID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 2011/08/28 | null | null | null | null |
Columns
| COLUMN_NAME | COLUMN_POSITION |
|---|---|
| REGION_ID | 1 |
| COLUMN_NAME | COLUMN_POSITION |
|---|---|
| COUNTRY_ID | 1 |
| COLUMN_NAME | COLUMN_POSITION |
|---|---|
| COUNTRY_ID | null |
| PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
|---|
| NAME | VALUE |
|---|---|
| NUM_ROWS | 25 |
| BLOCKS | null |
| AVG_ROW_LEN | 15 |
| SAMPLE_SIZE | 25 |
| LAST_ANALYZED | 2016/09/23 |
| LAST_ANALYZED_SINCE | 2016/09/23 |
Column Statistics
| TRIGGER_NAME | TRIGGER_TYPE | TRIGGER_OWNER | TRIGGERING_EVENT | STATUS | TABLE_NAME |
|---|
| OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
|---|---|---|---|---|---|
| HR | EMP_DETAILS_VIEW | VIEW | HR | COUNTRIES | TABLE |
References
| OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
|---|
| NAME | VALUE |
|---|---|
| CREATED | 2011/08/28 |
| LAST_DDL_TIME | 2011/08/28 |
| OWNER | HR |
| TABLE_NAME | COUNTRIES |
| TABLESPACE_NAME | null |
| CLUSTER_NAME | null |
| IOT_NAME | null |
| STATUS | VALID |
| PCT_FREE | 0 |
| PCT_USED | 0 |
| INI_TRANS | 0 |
| MAX_TRANS | 0 |
| INITIAL_EXTENT | null |
| NEXT_EXTENT | null |
| MIN_EXTENTS | null |
| MAX_EXTENTS | null |
| PCT_INCREASE | null |
| FREELISTS | null |
| FREELIST_GROUPS | null |
| LOGGING | null |
| BACKED_UP | N |
| NUM_ROWS | 25 |
| BLOCKS | null |
| EMPTY_BLOCKS | null |
| AVG_SPACE | null |
| CHAIN_CNT | 0 |
| AVG_ROW_LEN | 15 |
| AVG_SPACE_FREELIST_BLOCKS | 0 |
| NUM_FREELIST_BLOCKS | null |
| DEGREE | 1 |
| INSTANCES | 1 |
| CACHE | N |
| TABLE_LOCK | ENABLED |
| SAMPLE_SIZE | 25 |
| LAST_ANALYZED | 2016/09/23 |
| PARTITIONED | NO |
| IOT_TYPE | IOT |
| OBJECT_ID_TYPE | null |
| TABLE_TYPE_OWNER | null |
| TABLE_TYPE | null |
| TEMPORARY | N |
| SECONDARY | N |
| NESTED | NO |
| BUFFER_POOL | DEFAULT |
| ROW_MOVEMENT | DISABLED |
| GLOBAL_STATS | YES |
| USER_STATS | NO |
| DURATION | null |
| SKIP_CORRUPT | DISABLED |
| MONITORING | YES |
| CLUSTER_OWNER | null |
| DEPENDENCIES | DISABLED |
| COMPRESSION | DISABLED |
| COMPRESS_FOR | BASIC |
| DROPPED | NO |
| COMMENTS | country table. Contains 25 rows. References with locations table. |
| PARTITION_NAME | LAST_ANALYZED | NUM_ROWS | BLOCKS | SAMPLE_SIZE | HIGH_VALUE |
|---|
| INDEX_OWNER | INDEX_NAME | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | JOIN_INDEX | COLUMNS | COLUMN_EXPRESSION |
|---|---|---|---|---|---|---|---|---|---|---|
| HR | COUNTRY_C_ID_PK | UNIQUE | VALID | IOT - TOP | N | NO | null | NO | COUNTRY_ID | null |
| INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
|---|---|---|---|---|---|---|---|---|
| HR | COUNTRY_C_ID_PK | HR | COUNTRIES | COUNTRY_ID | 1 | 2 | 2 | ASC |