Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to retrieve last two days updated records?

Answer Posted / krishnakanth.ch

select * from date_Test
where dt between sysdate-2 and sysdate ;

Hope this works....
If not anyone please let me know...

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we handle two sessions in informatica?

1094


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3928


How do you load only null records into target?

1254


According to his methodology what all you need before you build a datawarehouse

1801


How many ways are there to create ports?

1404


What all join we can perform in LOOKUP transformation?

1022


What do think which one is the better joiner or look up?

1247


Explain the informatica workflow?

1127


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1223


How to load the data from people soft hrm to people soft erm using informatica?

1068


How can informatica be used for an organization?

1275


What is rank index in rank transformation?

1131


Explain direct and indirect flat file loading (source file type) - informatica

1359


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2252


Do you find any difficulty while working with flat files as source and target?

1149