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 vote288 views1 answer
Is not null postgresql
SQL
0 vote324 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote306 views1 answer
Mysql count multiple columns in one query
SQL
0 vote316 views1 answer
Create query in where clasue
SQL
0 vote297 views1 answer
Oracle archivemode
SQL
13 votes307 views5 answers
Select last row mysql
SQL
1 vote324 views1 answer
Mysql show database size in mb
SQL
0 vote318 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote312 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
7 votes303 views1 answer
Sql management studio display line numbers
SQL