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 vote212 views1 answer
Mysql where in maintain order
SQL
0 vote196 views1 answer
How to find unique key in sql
SQL
0 vote212 views1 answer
Oracle locked objects
SQL
11 votes223 views5 answers
Sql server reset identity
SQL
2 votes255 views1 answer
Remove foreign key constraints in postgres
SQL
32 votes208 views6 answers
Insert into values select
SQL
0 vote232 views1 answer
Mysql relationships between tables
SQL
0 vote198 views1 answer
Oracle last character of string
SQL
5 votes232 views1 answer
Oracle get ddl
SQL
0 vote204 views2 answers
Csv into data postgres
SQL