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

-1 vote327 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote301 views1 answer
Default column value in sql same as other column
SQL
0 vote329 views2 answers
What is the default password for sql server sa
SQL
1 vote333 views4 answers
Aggregate function in sql
SQL
0 vote339 views1 answer
Psql generate id in existing database
SQL
0 vote338 views1 answer
Wp_query raw sql
SQL
0 vote338 views1 answer
Convert excel into sqllite db using python
SQL
0 vote323 views2 answers
How to display enum value sql server
SQL
0 vote324 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote308 views1 answer
Sql change default collation to utf8
SQL