The following is a true story. We had our Oracle MRP system down for a couple of days because of a simple, yet hidden bug that went unnoticed for years until it hit us couple of days ago (somehow the image of a terrorist cell comes to mind).

In Oracle Applications (11.03) there is a table […]

Here are some facts you may want to consider if you use or are planning to use sequences in Oracle.

You cannot use CURRVAL and NEXTVAL in the following constructs:

A subquery in a DELETE, SELECT, or UPDATE statement A query of a view or of a materialized view […]