Table Functions

Previous posts in this category introduced a way to perform DML in a SELECT using the following technology: Table Functions Autonomous Transactions The following concepts were included: A REF CURSOR as a parameter Row by row (aka slow by slow) processing of the REF CURSOR Raw parallel query processing to try to overcome the slow by … Read more

In the first post in this category I introduced a way to perform DML in a SELECT using the following technology: Table Functions Autonomous Transactions In this post I’ll add the following: A REF CURSOR as a parameter Row by row (aka slow by slow) processing of the REF CURSOR Raw parallel query processing to try … Read more

It has long been a sort-of golden rule of Oracle database programming that Data Manipulation (Insert/Update/Delete) cannot be done by a SELECT statement. Note that I am not referring to DML statements that include a query to determine rows to process. Oracle Table Functions combined with Autonomous Transactions allow you to violate this rule as … Read more