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

33 votes169 views6 answers
Sql delete
SQL
1 vote254 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote157 views1 answer
Sql gather statistics to increase performance
SQL
6 votes156 views2 answers
How to copy data in sql
SQL
6 votes249 views1 answer
Check Table Exists
SQL
0 vote194 views1 answer
Query to insert image
SQL
0 vote169 views1 answer
Mysql create pool
SQL
0 vote169 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote162 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote160 views1 answer
Mysql isshow
SQL