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

3 votes325 views4 answers
Truncate syntax in sql
SQL
0 vote285 views1 answer
Hibernate with springboot mysql
SQL
1 vote286 views1 answer
Oracle case
SQL
5 votes293 views1 answer
Oracle ORA-00054 origin
SQL
0 vote359 views1 answer
Reindexing all tables sql server
SQL
4 votes289 views4 answers
Update select mysql
SQL
0 vote284 views2 answers
Php convert dbf to mysql
SQL
0 vote320 views1 answer
Mysql value ends with
SQL
1 vote300 views1 answer
Sql server kill all connections
SQL
0 vote289 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL