SQL

oracle drop index if exists

DECLARE
   index_not_exists EXCEPTION;
   PRAGMA EXCEPTION_INIT (index_not_exists, -1418);
BEGIN
   EXECUTE IMMEDIATE 'DROP INDEX index_name';
EXCEPTION
   WHEN index_not_exists THEN NULL;
END;