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 vote246 views1 answer
CREATE MULTIPLE FK
SQL
1 vote288 views2 answers
Last working day in week date function in sql
SQL
1 vote279 views1 answer
Error code 1055
SQL
0 vote316 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote293 views1 answer
Como saber si tengo mysql instalado
SQL
3 votes313 views2 answers
Oracle sql first day of month
SQL
1 vote249 views1 answer
Unique vs distinct sql
SQL
0 vote286 views2 answers
Create fulltext index mysql
SQL
4 votes283 views2 answers
Bulk kill mysql processlist
SQL
0 vote295 views2 answers
How to login to mysql as normal user in ubuntu
SQL