查詢EBS中LOV的SQL語句
1、幫助->關于：查找會話 SID : 507；
2、點一下LOV右邊的三點，觸發LOV事件；
3、運行如下代碼段：
DECLARE
l_sid NUMBER := :SID;
BEGIN
FOR cur_sql IN (SELECT sql_text
FROM v$sqltext_with_newlines t
WHERE t.address IN (SELECT s.prev_sql_addr
FROM v$session s
WHERE s.sid = l_sid
UNION
SELECT s.sql_address --如果查詢時間很短，可能存在sql_address中
FROM v$session s
WHERE s.sid = l_sid)
ORDER BY t.piece) LOOP
dbms_output.put_line(cur_sql.sql_text);
END LOOP;
END;
l_sid NUMBER := :SID;
BEGIN
FOR cur_sql IN (SELECT sql_text
FROM v$sqltext_with_newlines t
WHERE t.address IN (SELECT s.prev_sql_addr
FROM v$session s
WHERE s.sid = l_sid
UNION
SELECT s.sql_address --如果查詢時間很短，可能存在sql_address中
FROM v$session s
WHERE s.sid = l_sid)
ORDER BY t.piece) LOOP
dbms_output.put_line(cur_sql.sql_text);
END LOOP;
END;
浙公網安備 33010602011771號