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

1 vote159 views1 answer
Query for all indexes in table postgres
SQL
1 vote152 views2 answers
Datetrunc hour snowflake
SQL
4 votes150 views2 answers
Oracle default date format
SQL
0 vote160 views1 answer
Disable database droping sql
SQL
0 vote133 views1 answer
Mysql error 1452
SQL
3 votes144 views2 answers
Postgres inner join vs join
SQL
0 vote161 views2 answers
Starts and end with vowel sql
SQL
3 votes147 views3 answers
C# sql select
SQL
21 votes117 views7 answers
Table drop if exist sql server
SQL
0 vote142 views1 answer
Oracle select invalid views
SQL