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 vote235 views1 answer
Day of the week sqlite
SQL
1 vote276 views1 answer
Oracle grant select on schema
SQL
6 votes229 views3 answers
Check if string contains substring sql
SQL
0 vote239 views1 answer
Sql server synonym
SQL
2 votes208 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
4 votes206 views1 answer
Wilayah indonesia database
SQL
2 votes229 views2 answers
Mysql does sentence contain word
SQL
0 vote214 views1 answer
Proc sql not in working
SQL
0 vote212 views1 answer
Python connect to mysql in settings.py
SQL
1 vote230 views2 answers
Sql queries practice
SQL