Another nugget of the gold stuff from Rainer, this time dynamic queries in data templates. Not an earth shattering discovery but its a nicely laid out walk through of how to add lexicals to your data template based queries using a before fetch trigger in the database. you can find the article here:
http://www.oracle.com/global/de/community/bip/tipps/dynamische_queries/index_en.html
for the German readers among you, you get it in your native tongue too
http://www.oracle.com/global/de/community/bip/tipps/dynamische_queries/index.html
If you're a newbie to the data template scene you might check out the Data Template Progression post and a few others in the data template archives.
