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 vote125 views1 answer
Oracle synonym procedure dblink
SQL
0 vote121 views1 answer
Oracle date winter time
SQL
0 vote108 views1 answer
Automate mysql cli query
SQL
1 vote192 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote116 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote123 views1 answer
Open postgresql.conf in centos
SQL
0 vote114 views1 answer
Sql count null as 0
SQL
3 votes106 views2 answers
Mysql add 2 hours
SQL
0 vote117 views1 answer
Linebreak sql
SQL
6 votes191 views1 answer
Sql insert values into table
SQL