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 vote211 views1 answer
Oracle last connexion
SQL
1 vote215 views1 answer
Sql server get users
SQL
3 votes187 views2 answers
Current year sql
SQL
0 vote188 views1 answer
Execut sql python
SQL
0 vote200 views1 answer
Dapper run sql script with parameters
SQL
0 vote207 views1 answer
Sql examples from framework
SQL
1 vote209 views2 answers
Mysql error 1215
SQL
1 vote196 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote197 views1 answer
Mysql date + 1 day
SQL
0 vote193 views1 answer
Is not null postgresql
SQL