Drop index oracle

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

Oracle sql drop index

DROP INDEX index_name;

Similar codes

16 votes210 views2 answers
Add column if not exists mysql
SQL
1 vote195 views1 answer
Sql trigger before delete
SQL
7 votes224 views2 answers
MySQL IF without else
SQL
1 vote194 views1 answer
How to see all table partition in oracle
SQL
11 votes218 views1 answer
Oracle insert from select
SQL
0 vote215 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
1 vote218 views1 answer
Oracle nvl2
SQL
0 vote209 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote210 views1 answer
Normalization in database 2nd normal form
SQL
0 vote214 views1 answer
How to combine first and last nae into one columb sql
SQL