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 vote363 views1 answer
How to add boolean column in postgresql
SQL
0 vote339 views1 answer
Mysql find db contarint
SQL
6 votes348 views2 answers
If not exists insert sql
SQL
0 vote346 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote391 views2 answers
Oracle leftmost characters
SQL
0 vote351 views1 answer
Unique element in sql
SQL
10 votes332 views4 answers
Primary key sql
SQL
0 vote319 views2 answers
Avg() sql
SQL
1 vote396 views3 answers
Union SQL
SQL
0 vote355 views1 answer
Opening xampp mysql in cmd ubuntu
SQL