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. 1228811 fiddles created (16681 in the last week).

CREATE TABLE tab1(i INT);
 hidden batch(es)


DECLARE V_OBJECT_NAME VARCHAR2(30); BEGIN BEGIN V_OBJECT_NAME := DBMS_ASSERT.SQL_OBJECT_NAME('tab1'); EXECUTE IMMEDIATE 'DROP TABLE tab1'; EXCEPTION WHEN OTHERS THEN NULL; END; END; /
1 rows affected
 hidden batch(es)


DECLARE V_OBJECT_NAME VARCHAR2(30); BEGIN BEGIN V_OBJECT_NAME := DBMS_ASSERT.SQL_OBJECT_NAME('func1'); EXECUTE IMMEDIATE 'DROP FUNCTION func1'; EXCEPTION WHEN OTHERS THEN NULL; END; END; /
1 rows affected
 hidden batch(es)