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 votes170 views1 answer
Sql first day of current year
SQL
3 votes196 views2 answers
How to start mysql in terminal
SQL
1 vote182 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote226 views1 answer
Html css mobile menu arrow dropdown
SQL
1 vote183 views2 answers
Sql server add time to date
SQL
0 vote187 views1 answer
Get current date data in mysql
SQL
0 vote208 views1 answer
Hour differeence in mysql
SQL
3 votes188 views1 answer
Select count from table mysql
SQL
14 votes212 views2 answers
Oracle add attribute to table
SQL
1 vote209 views1 answer
Mysql previous year
SQL