Hi There,
Environment - Oracle 9i, Solaris
Here is the sql that works in CNV but not in TST.
SELECT /*+ FIRST_ROWS */ BUSINESS_UNIT_PO, PO_ID, TO_CHAR(PO_DT,'YYYY-MM-DD'), VENDOR_ID, NAME1 FROM PS_VCHR_PO_VW A WHERE BUSINESS_UNIT_PO=:1 ORDER BY BUSINESS_UNIT_PO, PO_ID
0 row in TST
If I replace the hit with ALL_ROWS, I get 772 rows.
Please advise.