It's not a bug, it's an Oracle feature. It happens with NO_DATA_FOUND exception only. And such behaviour is typical for all version of database. It is not documented anywhere in Oracle documentation. Just remeber and keep it in mind.
Now I show what I am talking about.
Thursday, September 13, 2012
Wednesday, September 12, 2012
Using DBMS_PARALLEL_EXECUTE package
In cases when you need to make any changes in data of huge table routines of DBMS_PARALLEL_EXECUTE package can help you to increase performance of your update statement.
The package was introduced in Oracle 11g.
In this article won't be illuminated all features of DBMS_PARALLEL_EXECUTE package, just basic moments. You can find more information in Oracle documentation.
The package was introduced in Oracle 11g.
In this article won't be illuminated all features of DBMS_PARALLEL_EXECUTE package, just basic moments. You can find more information in Oracle documentation.
Subscribe to:
Posts (Atom)