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 vote201 views1 answer
Mysql a from on this page has
SQL
2 votes198 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
2 votes189 views1 answer
Oracle cpu per session
SQL
0 vote148 views1 answer
Oracle list all stored procedures
SQL
0 vote224 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote253 views1 answer
Sql ssrs
SQL
0 vote195 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote251 views1 answer
Mysqlimport
SQL
0 vote288 views1 answer
Modificar tipo de dato sql server
SQL
0 vote217 views1 answer
Mysql date without time
SQL