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 vote188 views1 answer
How to close external sql connection in laravel
SQL
7 votes206 views4 answers
Database dump mysql command
SQL
0 vote168 views1 answer
Mysql count grouped rows
SQL
2 votes186 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote175 views1 answer
Sql select column names starting with
SQL
0 vote213 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
1 vote169 views3 answers
Execute sp in sql server
SQL
0 vote171 views1 answer
Drop tables from local database postgres pgadmin
SQL
4 votes193 views2 answers
Oracle unlock account
SQL
0 vote166 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL