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

2 votes236 views1 answer
Sqlplus clear screen
SQL
1 vote233 views1 answer
Oracle turn off constraint
SQL
0 vote248 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote220 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote221 views1 answer
Oracle add proxy
SQL
0 vote242 views1 answer
Mysql add to number
SQL
0 vote245 views1 answer
Openquery join two tables
SQL
0 vote226 views1 answer
Snap craft
SQL
0 vote246 views1 answer
Change date format in oracle query
SQL
0 vote233 views1 answer
Alter database name script
SQL