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

3 votes304 views2 answers
How to start postgresql on windows
SQL
0 vote334 views1 answer
Create table split string function in sql server
SQL
0 vote331 views1 answer
Load data infile mariadb slow
SQL
20 votes335 views1 answer
Get all table name in sql through php
SQL
1 vote293 views2 answers
How to check username in mysql command line
SQL
0 vote311 views1 answer
Mysql Digital Ocean connection problems
SQL
1 vote320 views1 answer
Create another table from existing table sql oracle
SQL
1 vote363 views1 answer
Sql select row with max date
SQL
1 vote282 views1 answer
Select not matching data from two tables
SQL
0 vote323 views3 answers
Join
SQL