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 vote138 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote144 views3 answers
Create and attach user to a postgresql database
SQL
0 vote177 views1 answer
ORACLE PARSE STRING
SQL
-1 vote209 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote145 views1 answer
Oracle service name view
SQL
0 vote140 views1 answer
Convert sql server guid to varbinary
SQL
0 vote150 views2 answers
How to display enum value sql server
SQL
-1 vote139 views1 answer
Mac mysql workbench console
SQL
4 votes152 views3 answers
Count with where
SQL
1 vote159 views2 answers
Oracle leftmost characters
SQL