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

0 vote219 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote228 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote236 views1 answer
Stop psql server windows
SQL
4 votes193 views2 answers
Postgresql reset sequence
SQL
2 votes203 views1 answer
Sql find missing values between two tables
SQL
20 votes214 views4 answers
Reset auto increment in MySQL
SQL
0 vote198 views1 answer
Sql server express download
SQL
15 votes199 views1 answer
Mysql int range
SQL
0 vote210 views1 answer
Install sql server windows 10
SQL
4 votes207 views1 answer
Conda install sqlalchemy
SQL