Oracle sql drop index

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

0 vote125 views1 answer
Set Mamp mysql globally
SQL
0 vote128 views2 answers
How to display enum value sql server
SQL
1 vote123 views1 answer
Second last highest id in sql
SQL
3 votes118 views1 answer
Kill mysql processlist in whose time more than 200
SQL
1 vote110 views1 answer
Md5 encryption for existing records
SQL
2 votes70 views1 answer
Oracle current date without time
SQL
0 vote117 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote117 views1 answer
Mysql workbench primary key
SQL
8 votes116 views2 answers
Change name of colum in sql table
SQL
0 vote131 views1 answer
Postgres grep entire database
SQL