Home » Developer & Programmer » Forms » How to retrieve data from oracle database on the basis of only one user input
How to retrieve data from oracle database on the basis of only one user input [message #168663] Fri, 21 April 2006 09:12 Go to next message
aniket_bhonde
Messages: 1
Registered: April 2006
Junior Member
Dear All
I want to retrieve data from oracle database on the basis of only one user input-date.But the selection of data should be such that on the basis of that date entered it should retrieve data between that date and 2 days prior to the input date.For example if the user enters 12-apr-06 as the date then records ranging between 10-apr-06 and 12-apr-06 should be retrieved.i tried using &user_date but it is not giving me the desired output.Can anybody help me regarding the same?

Report message to a moderator

Re: How to retrieve data from oracle database on the basis of only one user input [message #168849 is a reply to message #168663] Sun, 23 April 2006 18:56 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Is this in a form or at the sql*plus prompt?

Try "your_date between trunc(sysdate)-2 and sysdate"

David

Report message to a moderator

Previous Topic: Can i call a trigger
Next Topic: how to controll menu item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:43:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.