We are upgrading Oracle Forms from 6i to 11g. We have Run_Product in menus:
Run_Product(REPORTS, 'aged_sum_grp', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, null);
Would you please provide step by step instructions of how to convert this line in 11g.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…