用于查询当前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;
转载于:https://blog.51cto.com/baser/1344464