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 vote397 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote352 views1 answer
User defined variables in sql
SQL
0 vote354 views1 answer
How get data from database if id not found then search another column
SQL
22 votes380 views4 answers
Mysql date_format
SQL
0 vote361 views1 answer
Mysql subdate
SQL
0 vote347 views1 answer
Sql grant select only
SQL
0 vote356 views1 answer
Oracle sql count occurrences of value in column
SQL
2 votes385 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
15 votes347 views6 answers
Psql
SQL
0 vote351 views1 answer
Postgres : ERROR: division by zero
SQL