By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 |
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | 0 |
1 rows affected
| EMPID | DEPARTMENT | DESIGNATION | SALARY |
|---|---|---|---|
| 1 | Sales | Jenny | 100000 |
| TABLE_NAME | TABLESPACE_NAME | CLUSTER_NAME | IOT_NAME | STATUS | PCT_FREE | PCT_USED | INI_TRANS | MAX_TRANS | INITIAL_EXTENT | NEXT_EXTENT | MIN_EXTENTS | MAX_EXTENTS | PCT_INCREASE | FREELISTS | FREELIST_GROUPS | LOGGING | BACKED_UP | NUM_ROWS | BLOCKS | EMPTY_BLOCKS | AVG_SPACE | CHAIN_CNT | AVG_ROW_LEN | AVG_SPACE_FREELIST_BLOCKS | NUM_FREELIST_BLOCKS | DEGREE | INSTANCES | CACHE | TABLE_LOCK | SAMPLE_SIZE | LAST_ANALYZED | PARTITIONED | IOT_TYPE | OBJECT_ID_TYPE | TABLE_TYPE_OWNER | TABLE_TYPE | TEMPORARY | SECONDARY | NESTED | BUFFER_POOL | FLASH_CACHE | CELL_FLASH_CACHE | ROW_MOVEMENT | GLOBAL_STATS | USER_STATS | DURATION | SKIP_CORRUPT | MONITORING | CLUSTER_OWNER | DEPENDENCIES | COMPRESSION | COMPRESS_FOR | DROPPED | SEGMENT_CREATED | INMEMORY | INMEMORY_PRIORITY | INMEMORY_DISTRIBUTE | INMEMORY_COMPRESSION | INMEMORY_DUPLICATE | EXTERNAL | HYBRID | CELLMEMORY | INMEMORY_SERVICE | INMEMORY_SERVICE_NAME | MEMOPTIMIZE_READ | MEMOPTIMIZE_WRITE | HAS_SENSITIVE_COLUMN | LOGICAL_REPLICATION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EMPLOYEE_INFO | USERS | null | null | VALID | 10 | null | 1 | 255 | 65536 | 1048576 | 1 | 2147483645 | null | null | null | YES | N | null | null | null | null | null | null | null | null | 1 | 1 | N | ENABLED | null | null | NO | null | SYSTEM GENERATED | FIDDLE_IDRLXKJZFTNXLAWUHAYI | EMPLOYEE_INFO_OBJ | N | N | NO | DEFAULT | DEFAULT | DEFAULT | DISABLED | NO | NO | null | DISABLED | YES | null | DISABLED | DISABLED | null | NO | YES | DISABLED | null | null | null | null | NO | NO | null | null | null | DISABLED | DISABLED | NO | ENABLED |