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 vote223 views1 answer
How to login to mysql in homestead
SQL
0 vote216 views1 answer
Top 3 salary in sql
SQL
0 vote203 views1 answer
Psql no such file or directory
SQL
5 votes210 views2 answers
Mysql drop table cascade
SQL
2 votes214 views1 answer
Oracle index size calculation
SQL
41 votes252 views6 answers
Alter table add column in SQL Server
SQL
0 vote220 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote209 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote206 views1 answer
How to find the most occuring in SQL
SQL
3 votes212 views3 answers
Mysql get table size
SQL