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 vote195 views1 answer
Go install mysql
SQL
-2 votes274 views1 answer
Mysql not empty
SQL
0 vote197 views2 answers
Oracle create chain rule
SQL
1 vote190 views1 answer
Restart identity postgresql
SQL
0 vote185 views1 answer
Learn sqlite dart
SQL
0 vote270 views1 answer
Get enginge db mysql
SQL
2 votes218 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
1 vote189 views2 answers
Mysql trim whitespace
SQL
0 vote203 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote190 views1 answer
Remove from table where
SQL