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

6 votes177 views1 answer
Rank function in oracle with example
SQL
18 votes271 views3 answers
Get the list of all tables in sql server
SQL
1 vote188 views1 answer
Last 6 months postgresql
SQL
10 votes194 views3 answers
Insert into auto increment mysql
SQL
0 vote210 views1 answer
Postegresql update to null
SQL
0 vote232 views1 answer
"Hello User Name"
SQL
2 votes202 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote193 views1 answer
Oracle webcenter content search enginer
SQL
0 vote223 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote236 views1 answer
Drop a view in sqlite
SQL