如何获取OracleEBSForm中后台取数SQL？
1.先获取SID
帮助-关于Oracle Applications
或用个性化
=(SELECT t.sid FROM v$mystat t where rownum = 1)
2.打开LOV
点击…来打开LOV进行搜索
3.用plSQLdev等软件根据SID查询所用sql查询语句
SELECT s.prev_sql_addr,s.sql_address FROM v$session s WHERE s.sid = 1643;
SELECT sql_text FROM v$sqltext_with_newlines t WHERE t.address = '070000000429FFE8' ORDER BY t.piece;
