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 vote200 views1 answer
Regex mongoose
SQL
0 vote205 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote204 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote179 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote178 views1 answer
Order by with where clause in mysql
SQL
1 vote219 views1 answer
Oracle columns table
SQL
0 vote204 views2 answers
Create row number in sql
SQL
-1 vote189 views1 answer
Mysql delete duplicate rows except one
SQL
22 votes216 views3 answers
How to join three tables in sql using joins
SQL
0 vote196 views1 answer
Mysql grant access to one database
SQL