Quest has recently aquired Qnxo which they will make available for free on ToadWorld.com. They have also renamed the product to from Qnxo (Quality iN, eXcellence Out) to Qcgu (Quest Code Generation Utility). Since the acronym doesn’t sound too good, it will probably be referred to as CodeGen. I have been testing the new version and it looks really good.
But still, there is no support for parsing views that refer to mulitiple tables. I am currently working on a script as well as PL/SQL code to parse a view and use it’s contents in a script, for example to create
INSTEAD OF triggers on views. Currently the code is working for simple views, that just combine fields from different tables. I am still working on parsing the views that use special functions on fields, like Date display, performing calculation functions etc.
I will post both the code and the scripts here, as soon as I have them working a bit better.