I don't want to have the error when I drop a table although the table doesn't exist I am using Oracle 12c and I am not interesting to have an error while droping my table 'CONTINENT' in case it doesn't exist.

I did this

set echo on

set serveroutput on
alter session set current_schema=WORK_ODI;
set verify off
set pause off
--
WHENEVER SQLERROR CONTINUE  

drop table  CONTINENT;

COMMIT;

EXIT;


but it coudn't skipe the error when the table doesn't exist, how can I fix this problem please
Unfortunately Oracle does not have anything like for example IF EXISTS in MySQL. You can do the above in a PL/SQL block, catch the exception, then do nothing with it.

begin
  execute immediate 'drop table continent';
  exception when others then null;
end;
/