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 vote134 views1 answer
Plsql check for string in numeric
SQL
58 votes288 views4 answers
Mysql drop column
SQL
0 vote141 views1 answer
Python dictionary to sql update
SQL
1 vote138 views1 answer
Oracle stop
SQL
0 vote125 views1 answer
Oracle archivelog usage
SQL
0 vote136 views1 answer
Sqlalchemy get schema from database
SQL
0 vote139 views1 answer
Oracle change password expiration policy
SQL
0 vote148 views1 answer
Synapse sql table set pk
SQL
35 votes137 views5 answers
Sql alter column
SQL
0 vote143 views2 answers
Reseed sql identity
SQL