Generate Insert/Update SQL for DataStage Oracle Connector Automatically (Updated)

CodeProject
Last year I published a post for automatically generating insert/update SQL used in DataStage Oracle connectors. I used Oracle 11g's new function LISTAGG(), which resulted in 2 major limitations.

1. It only applies to Oracle 11g or later.
2. LISTAGG has 4000-character length limit. So it doesn't work on wide tables with more than 100 columns.

Here is an updated version without using LISTAGG(), hence removing the limitations.

Insert SQL:

Update SQL: