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

13 votes129 views3 answers
Sql online code
SQL
20 votes126 views3 answers
SQL query rename table
SQL
0 vote142 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
3 votes123 views1 answer
Postgres kill running query
SQL
1 vote136 views3 answers
How to truncate table with foreign key constraint
SQL
3 votes164 views1 answer
Oracle nextval insert
SQL
52 votes290 views6 answers
Rename column sql
SQL
1 vote129 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
9 votes149 views1 answer
Alter table column change data type to text mysql
SQL
22 votes122 views4 answers
Show list of users in mysql
SQL