帮助->关于
会话 SID : 507
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;
查询EBS中LOV的SQL语句,布布扣,bubuko.com
查询EBS中LOV的SQL语句
原文:http://www.cnblogs.com/chinaxin/p/3834514.html