clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36249 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)