Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE customers(something NUMBER);
DECLARE
  v_data RAW(32767);
  v_sql  CLOB;
  v_spos  PLS_INTEGER := 1;
  v_epos  PLS_INTEGER;
  v_len   PLS_INTEGER;
  v_stmt  CLOB;
BEGIN
  v_data := UTL_RAW.CAST_TO_RAW(
    'drop table customers purge;
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)
); '
  );
  v_sql := UTL_RAW.CAST_TO_VARCHAR2(v_data);

  LOOP
    EXIT WHEN v_spos > LENGTH(v_sql);
    v_epos := INSTR(v_sql, ';', v_spos, 1);
    
    IF v_epos = v_spos THEN
      v_spos := v_epos + 1;
      CONTINUE;
    END IF;

    IF v_epos < 1 THEN
      v_stmt := SUBSTR(v_sql, v_spos);
    ELSE
      v_stmt := SUBSTR(v_sql, v_spos, v_epos - v_spos);
    END IF;

    IF NOT REGEXP_LIKE(v_stmt, '^\s*$') THEN
      DBMS_OUTPUT.PUT_LINE(v_stmt);
      BEGIN
        EXECUTE IMMEDIATE v_stmt;
        DBMS_OUTPUT.PUT_LINE('success');
      EXCEPTION
        WHEN OTHERS THEN
          DBMS_OUTPUT.PUT_LINE(SQLERRM);
      END;
    END IF;

    EXIT WHEN v_epos < 1;
    v_spos := v_epos + 1;
  END LOOP;
END;
/
1 rows affected

dbms_output:
drop table customers purge
success

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)
)
success

SELECT * FROM USER_TAB_COLUMNS;


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

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