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

4 votes323 views3 answers
Oracle sql first day of quarter
SQL
27 votes355 views3 answers
Mysql show tables in database
SQL
0 vote351 views1 answer
Influxdb clone measurement
SQL
0 vote326 views1 answer
Change schema of all tables postgres
SQL
2 votes323 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote347 views1 answer
Varchar2 length in oracle
SQL
2 votes336 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
1 vote320 views1 answer
Mysql select month and year
SQL
0 vote348 views1 answer
Sql column contains special character
SQL
9 votes361 views2 answers
SELECT User,Host FROM mysql.user;
SQL