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 vote334 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
22 votes324 views2 answers
Mysql show all tables
SQL
14 votes345 views4 answers
Remove record from table sql
SQL
0 vote331 views1 answer
Sql offfset
SQL
0 vote356 views1 answer
Repeatable read trong sql server
SQL
0 vote371 views1 answer
How to run mysql on terminal mac
SQL
5 votes324 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote305 views1 answer
Deleted table in sql trigger
SQL
2 votes352 views1 answer
Postgresql update sequence next value
SQL
0 vote345 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL