I want to have an output if the drop table was success or fail, is this the best way to do it?
SET serveroutput on
DECLARE
x number;
BEGIN
EXECUTE IMMEDIATE 'drop table mytable';
DBMS_OUTPUT.put_line('Success.');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line('Fail.');
END;
Thanks