Home » SQL & PL/SQL » SQL & PL/SQL » SQL statement help for date parameters
SQL statement help for date parameters [message #20485] Tue, 28 May 2002 12:48 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hello All,

Can someone help me with this sql statement.

I need to write a SQL statement to retreive data on the weekending_date where in the user will key in the two weekending_dates at the time of running the script.

How do I pass date parameter values ?

Any help on this would be highly appreciated.

Thanks

Report message to a moderator

Re: SQL statement help for date parameters [message #20492 is a reply to message #20485] Wed, 29 May 2002 02:44 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
SIR,

PLEASE EXPLAIN ME MORE.

K.SREENIVASAN

Report message to a moderator

Re: SQL statement help for date parameters [message #20494 is a reply to message #20485] Wed, 29 May 2002 05:10 Go to previous message
Arpit
Messages: 99
Registered: March 2001
Member
Hello K.Sreenivasan,

Thanks for your response,

I need help on a SQL statement that I'm running in MS Query connecting through Oracle 8.0.5 ODBC to retreive some data from my employee table.

I need to pass "hiredate" parameter values during run time. How can i include this in my SQL script.

ex: will this work:-
SELECT SCOTT_EMP.HIREDATE
FROM SCOTT_EMP
WHERE (((SCOTT_EMP.HIREDATE) Between ? And ?));

Report message to a moderator

Previous Topic: Slow create view statements - Please help it is urgent
Next Topic: Can PL/SQL executed in shell ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 21:31:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.