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 vote165 views1 answer
Disable database droping sql
SQL
8 votes144 views2 answers
Phpmyadmin default password
SQL
0 vote152 views1 answer
Mysql query to add hours to column in table
SQL
0 vote164 views1 answer
Compare if is null sql
SQL
0 vote157 views1 answer
Oracle exchange subpartition
SQL
50 votes222 views4 answers
Sql alter type of column
SQL
0 vote142 views2 answers
Update information in a mysql column
SQL
15 votes140 views7 answers
MYSQL
SQL
0 vote155 views1 answer
Test sql query
SQL
0 vote152 views1 answer
Sql max min
SQL