By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
dbms_output:
424547494E0A20204558454355544520494D4D454449415445202764726F70207461626C6520637573746F6D657273207075726765273B0A20204558454355544520494D4D4544494154452027435245415445205441424C4520637573746F6D65727328637573746F6D65725F6964206E756D62657228313029204E4F54204E554C4C2C202020637573746F6D65725F6E616D6520766172636861723228353029204E4F54204E554C4C2C2063697479207661726368617232283530292C20434F4E53545241494E5420637573746F6D6572735F706B205052494D415259204B45592028637573746F6D65725F69642929273B0A454E443B
1 rows affected
dbms_output:
BEGIN
EXECUTE IMMEDIATE 'drop table customers purge';
EXECUTE IMMEDIATE 'CREATE TABLE customers(customer_id number(10) NOT NULL, customer_name varchar2(50) NOT NULL, city varchar2(50), CONSTRAINT customers_pk PRIMARY KEY (customer_id))';
END;
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUSTOMERS | CUSTOMER_ID | NUMBER | null | null | 22 | 10 | 0 | N | 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 |
| CUSTOMERS | CUSTOMER_NAME | VARCHAR2 | null | null | 50 | null | null | N | 2 | null | null | null | 0x | 0x | null | null | null | null | null | CHAR_CS | 50 | NO | NO | null | 50 | B | NO | YES | NONE | NO | NO | null | null | null | USING_NLS_COMP |
| CUSTOMERS | CITY | VARCHAR2 | null | null | 50 | null | null | Y | 3 | null | null | null | 0x | 0x | null | null | null | null | null | CHAR_CS | 50 | NO | NO | null | 50 | B | NO | YES | NONE | NO | NO | null | null | null | USING_NLS_COMP |