Oracle create index if not exists

DECLARE
    already_exists EXCEPTION;
    columns_indexed EXCEPTION;
    PRAGMA EXCEPTION_INIT ( already_exists, -955 );
    PRAGMA EXCEPTION_INIT (columns_indexed, -1408);
BEGIN
    EXECUTE IMMEDIATE 'CREATE INDEX ord_customer_ix ON orders (customer_id)';
    dbms_output.put_line('created');
EXCEPTION
    WHEN already_exists OR columns_indexed THEN
        dbms_output.put_line('skipped');
END;

Source: stackoverflow.com

Similar codes

0 vote124 views2 answers
What is rownum in oracle
SQL
1 vote112 views1 answer
Mysql backup skip table
SQL
1 vote97 views3 answers
How to filter repeated same result using sql query
SQL
8 votes98 views2 answers
Phpmyadmin password
SQL
1 vote113 views1 answer
Name of today sql
SQL
0 vote110 views1 answer
Mysql select where field like in list
SQL
2 votes95 views1 answer
Oracle sql drop column if exists
SQL
21 votes124 views3 answers
Average sql
SQL
0 vote100 views1 answer
Mysql database is not starting in xampp
SQL
1 vote102 views1 answer
Sql upsert
SQL