Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name ( id NUMBER );
CREATE TABLE "lower_case_name" ( id NUMBER );
CREATE TABLE "3RD_TABLE" ( id NUMBER );
CREATE TABLE "SELECT" ( id NUMBER );
select 'drop table '||table_name||' cascade constraints;' from user_tables;

'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'

drop table TABLE_NAME cascade constraints;

drop table lower_case_name cascade constraints;

drop table 3RD_TABLE cascade constraints;

drop table SELECT cascade constraints;

drop table TABLE_NAME cascade constraints;
drop table lower_case_name cascade constraints;
ORA-00942: table or view does not exist

drop table 3RD_TABLE cascade constraints;
ORA-00903: invalid table name

drop table SELECT cascade constraints;
ORA-00903: invalid table name

select 'drop table "'||table_name||'" cascade constraints;' from user_tables;

'DROPTABLE"'||TABLE_NAME||'"CASCADECONSTRAINTS;'

drop table "lower_case_name" cascade constraints;

drop table "3RD_TABLE" cascade constraints;

drop table "SELECT" cascade constraints;

drop table "lower_case_name" cascade constraints;
drop table "3RD_TABLE" cascade constraints;
drop table "SELECT" cascade constraints;