Saturday, February 09, 2008

OWB SQL generation

Mappings created in OWB generate ANSI SQL by default. While this is good universal methodology, people like me understand the normal pl/sql code of oracle just by looking at it. Wanted to change this and found out that this can be changed from the options of the mapping. in the control center, right click on mapping -> configure -> uncheck the generate ANSI SQL checkbox. now i see familiar code!

0 comments:

Clicky Web Analytics