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 vote267 views2 answers
Close external port 3306 with iptables
SQL
0 vote326 views1 answer
Stop and start mysql
SQL
0 vote299 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote252 views1 answer
Json not contains mysql
SQL
0 vote315 views2 answers
Fanyi
SQL
0 vote379 views1 answer
Sql insert exemplo
SQL
1 vote281 views1 answer
How to get previous year from sysdate in oracle
SQL
14 votes277 views5 answers
Sql oracle limit
SQL
0 vote274 views2 answers
Alter table add multiple columns mysql
SQL
3 votes276 views2 answers
How to delete git repo locally
SQL