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 vote336 views1 answer
Sql server cannot create database diagram
SQL
0 vote327 views1 answer
Sql server convert date to weekday
SQL
0 vote346 views1 answer
Order by with where clause in mysql
SQL
0 vote336 views1 answer
Sql trying to delete database in use
SQL
48 votes393 views3 answers
Psql create database
SQL
2 votes335 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote368 views1 answer
Mysql dump with table query
SQL
0 vote353 views1 answer
Sql order by except one row
SQL
0 vote355 views1 answer
Multiple like values for single column postgres
SQL
3 votes347 views2 answers
How to load files in mysql
SQL