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 vote247 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote234 views1 answer
Merge clause with inner join
SQL
3 votes219 views2 answers
Oracle sql drop sequence
SQL
1 vote250 views1 answer
Postgresql export output table as a csv
SQL
1 vote255 views2 answers
Procedure syntax
SQL
1 vote246 views1 answer
Drop column if exists sql server
SQL
4 votes225 views2 answers
Oracle unliock account
SQL
18 votes233 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote263 views2 answers
Start mysql server using docker
SQL
0 vote233 views2 answers
Csv into data postgres
SQL