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

3 votes125 views1 answer
What is having clause
SQL
0 vote132 views1 answer
Sql revert migration
SQL
6 votes141 views2 answers
Oracle trigger
SQL
14 votes136 views2 answers
Sql cast
SQL
1 vote219 views1 answer
Mysql monthname
SQL
0 vote131 views1 answer
Mysql_error replacement
SQL
2 votes132 views1 answer
Get hour from date sql
SQL
0 vote131 views1 answer
SAP Return
SQL
0 vote140 views1 answer
Sql use with to get value counts and percentages
SQL
3 votes131 views1 answer
Créer une table sql
SQL