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

2 votes190 views1 answer
Sql skip the first row
SQL
2 votes178 views1 answer
Wait delay in sql server
SQL
20 votes170 views4 answers
Reset auto increment in MySQL
SQL
22 votes176 views4 answers
Tsql rename table
SQL
5 votes170 views2 answers
Mysql date greater than 30 days
SQL
0 vote161 views1 answer
Postgresql parse json array
SQL
21 votes167 views4 answers
Add column mssql
SQL
1 vote183 views1 answer
Continue in sql
SQL
1 vote185 views1 answer
How to delete data from sql database in android
SQL
1 vote154 views2 answers
Difference between in and between in sql
SQL