Thursday, September 13, 2012

NO_DATA_FOUND is not raised from a function in Oracle SQL

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.

Wednesday, September 12, 2012


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.