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;

Source: stackoverflow.com

Similar codes

0 vote228 views1 answer
Ms sql print more than 1 variable
SQL
1 vote236 views1 answer
Alter database datafile maxsize 32g
SQL
58 votes357 views4 answers
Mysql drop column
SQL
0 vote210 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote260 views1 answer
Osm2pgsql mac
SQL
0 vote211 views2 answers
Sql server Insert Into table
SQL
3 votes203 views1 answer
Force using index oracle
SQL
0 vote233 views1 answer
Psql initialization
SQL
0 vote186 views1 answer
How to to get current date and time in sql
SQL
8 votes206 views1 answer
Script to add datafile to tablespace
SQL