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

5 votes245 views1 answer
Ascending order and where in sql
SQL
32 votes281 views6 answers
Insert select
SQL
3 votes257 views2 answers
Oracle grants
SQL
7 votes269 views4 answers
Lowest salary in sql
SQL
17 votes255 views2 answers
Mysql date to string
SQL
0 vote245 views1 answer
Xampp mysql version
SQL
1 vote269 views1 answer
Cross schema query oracle 2 users
SQL
0 vote306 views1 answer
Insert into using contant values and source table columns with sql
SQL
2 votes265 views1 answer
Orcale index size
SQL
1 vote249 views2 answers
Update with inner join sql server
SQL