clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1716817 fiddles created (23909 in the last week).

CREATE TABLE table_name ( id NUMBER );
 hidden batch(es)


CREATE TABLE "lower_case_name" ( id NUMBER );
 hidden batch(es)


CREATE TABLE "3RD_TABLE" ( id NUMBER );
 hidden batch(es)


CREATE TABLE "SELECT" ( id NUMBER );
 hidden batch(es)


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;
 hidden batch(es)


drop table TABLE_NAME cascade constraints;
 hidden batch(es)


drop table lower_case_name cascade constraints;
ORA-00942: table or view does not exist
 hidden batch(es)


drop table 3RD_TABLE cascade constraints;
ORA-00903: invalid table name
 hidden batch(es)


drop table SELECT cascade constraints;
ORA-00903: invalid table name
 hidden batch(es)


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;
 hidden batch(es)


drop table "lower_case_name" cascade constraints;
 hidden batch(es)


drop table "3RD_TABLE" cascade constraints;
 hidden batch(es)


drop table "SELECT" cascade constraints;
 hidden batch(es)