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

1 vote147 views1 answer
Psql client write to bash variable
SQL
15 votes128 views4 answers
Mysql export database command line
SQL
0 vote103 views1 answer
Drop specific row postgresql
SQL
0 vote61 views1 answer
Mysql date + 1 day
SQL
3 votes104 views1 answer
RENAME table pl sql
SQL
16 votes108 views2 answers
Add column if not exists mysql
SQL
0 vote102 views1 answer
How to reset table in sql server
SQL
0 vote128 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
1 vote106 views1 answer
Postgresql update auto_increment value
SQL
1 vote97 views1 answer
How to start with sql
SQL