Problem in accessing Data from Oracle

kondeti · Post by **kondeti** » Fri Aug 04, 2006 1:28 am

Hi

I need to pull the data from source oracle system. i.e., for yesterday data. For this I am putting condition in where cluase as sysdate-1. But i got access for this source system from night 11:00 P.M to Early Morning 4:00 A.M. in this case 2 different dates are involving. I want to pull before 12'O colock data. how it is possible. any body can help me.

Thanks&Regards
kondeti.

kumar_s · Post by **kumar_s** » Fri Aug 04, 2006 1:40 am

Get the system date (SYSDATE) while you start the batch, and subtract with 1 day and pass it as an parameter to the job which runs for the various period. So that it wont varies for the whole flow.