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

5 votes138 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote126 views1 answer
Increase speed of like queries postgres
SQL
1 vote129 views1 answer
Postgresql float 2 decimal places
SQL
37 votes114 views3 answers
Duplicate records in sql
SQL
1 vote123 views4 answers
Mysqldump 1 table only
SQL
0 vote136 views1 answer
Cube oracle
SQL
0 vote121 views2 answers
Sql trigger difference between for and after
SQL
2 votes119 views3 answers
How to pass password mysql command line
SQL
0 vote132 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
7 votes127 views3 answers
Sql server reset auto increment
SQL