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 vote364 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote305 views1 answer
Strat with in sql
SQL
3 votes334 views2 answers
Sql select data from last week
SQL
0 vote377 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote348 views1 answer
How to run mysql in git bash
SQL
0 vote326 views1 answer
Inser into example
SQL
0 vote338 views1 answer
Sql server change schema of a table
SQL
0 vote369 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote342 views1 answer
Sql alchemy escape ; in insert statement
SQL
2 votes340 views2 answers
Mamp connect mysql terminal
SQL