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 vote122 views1 answer
Sql database connectivity
SQL
0 vote177 views1 answer
Updating database in sql
SQL
0 vote128 views1 answer
Oracle archivelog usage
SQL
11 votes125 views4 answers
Query DISTINCT
SQL
1 vote129 views1 answer
Mysql text to decimal
SQL
2 votes128 views4 answers
Check timezone of mysql database
SQL
1 vote131 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote167 views2 answers
Sql unique
SQL
0 vote128 views3 answers
Select random sql
SQL
2 votes119 views2 answers
Postgresql date at timezone
SQL