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

3 votes266 views5 answers
Sql select
SQL
0 vote229 views1 answer
How to see password mysql vestacp
SQL
3 votes223 views2 answers
Having in mysql
SQL
0 vote259 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote242 views1 answer
How to set sql_mode for a query in CI model
SQL
20 votes228 views4 answers
Reset auto increment in MySQL
SQL
0 vote351 views5 answers
Right join
SQL
0 vote251 views1 answer
Sql get count without group by
SQL
0 vote261 views1 answer
Authentication modes in sql server
SQL
0 vote254 views1 answer
Call object contructor and call methods of object
SQL