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 vote157 views1 answer
How to check database engine in mysql
SQL
3 votes133 views1 answer
Postgresql cast
SQL
1 vote220 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
1 vote126 views1 answer
Sql auto timestamp
SQL
0 vote134 views4 answers
Mysql select bottom 10 rows
SQL
1 vote129 views1 answer
Influxdb export to csv
SQL
0 vote142 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote172 views1 answer
Linux upload database to mysql
SQL
0 vote156 views1 answer
Python connect to mysql in settings.py
SQL
1 vote160 views1 answer
Postgres power
SQL