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

5 votes135 views1 answer
Oracle get nls settings
SQL
1 vote131 views1 answer
PLS-00225 type
SQL
0 vote130 views1 answer
Restart sql server command line linux
SQL
-1 vote138 views5 answers
Online sql to linq generator
SQL
4 votes137 views2 answers
How to delete row in sql
SQL
0 vote133 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
1 vote156 views2 answers
Mysql error 1215
SQL
2 votes154 views1 answer
Sql get the name of user pc
SQL
4 votes142 views1 answer
Mysql not equal
SQL
0 vote149 views1 answer
Mysql c commands
SQL