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 vote310 views1 answer
Reindex mssql table
SQL
0 vote271 views1 answer
How to insert same table data using mysql query
SQL
0 vote302 views1 answer
How to find the most occuring in SQL
SQL
1 vote315 views1 answer
Sql set auto increment back to 0
SQL
0 vote283 views1 answer
Can sqldatareader be null
SQL
1 vote303 views1 answer
Pgsql sum switch case
SQL
2 votes286 views1 answer
How to make insert script from table in SQL server
SQL
0 vote369 views1 answer
TSQL Find csv file in folder
SQL
0 vote335 views1 answer
Psql check if sql script is valid
SQL
0 vote295 views1 answer
Load data from text file to mysql database on mac terminal
SQL