用于查询当前form界面上LOV所执行的SQL
1、获取会话SID sessionID
菜单栏 --》帮助 --》 关于...
2、选取LOV
3、查询SQL
SELECT s.Prev_Sql_Addr, s.Sql_Address FROM V$session s WHERE s.Sid = 374;
SELECT Sql_Text FROM V$sqltext_With_Newlines t WHERE t.Address = '070000007AC50208' ORDER BY t.Piece;
SELECT Sql_Text, s.Prev_Sql_Addr, s.Sql_Address FROM V$session s, V$sqltext_With_Newlines t WHERE s.Prev_Sql_Addr = t.Address(+) AND s.Sid = 393;