查找LOV的SQL脚本

查找LOV的SQL脚本

1.Get the session Id(SID) from the FORM 

菜单Help->About Oracle Applications->session ID

2.利用下面的Sql查询

SELECT s.PREV_SQL_ADDR,s.PREV_SQL_ID,t.sql_text 
FROM v$sqltext_with_newlines t,V$session s 
WHERE 1 = 1 
And t.address = s.prev_sql_addr 

and s.SID =&SID