-- This Oracle profile script is used to collect database profile information. -- It needs to be run as a user who has read privileges on the V$ virtual tables and the DBA_ tables. -- The script will ...

可以利用SYS_CONTEXT给视图传递参数。首先你要创建一个CONTEXT, 比如叫做MY_CTX, 然后在你的视图定义加上WHERE条件： WHERE t.CREATE ...

AND PRH.CREATION_DATE BETWEEN PPF1.EFFECTIVE_START_DATE AND PPF1.EFFECTIVE_END_DATE AND PPF2.AGENT_ID(+) = MSI.BUYER_ID AND (:P_PRAPPROVE_FROM_DT IS NULL OR TRUNC(PRH.APPROVED_DATE) BETWEEN ...

SELECT GHV.DEFAULT_EFFECTIVE_DATE DEFAULT_DATE -----栏位：有效时间 , SUBSTR(GHV.BATCH_NAME,1,12) TNAME -----栏位：总帐号码 , GHV.DOC_SEQUENCE_VALUE DOC ...