Home » SQL & PL/SQL » SQL & PL/SQL » Procedure
Procedure [message #205010] Thu, 23 November 2006 00:56 Go to next message
arunprabhu29917
Messages: 15
Registered: September 2006
Location: Tamilnadu
Junior Member

Hi to all,

Can anyone help me,

The procedure should take two input dates and return in between dates as output.

I.E input as 12/10/2001(mm/dd/yyyy) and other input as 16/10/2001 means It will fetch the inbetween four datas. Like 13,14,15,16..

Thanks & Regards,
Arunprabhu
Re: Procedure [message #205019 is a reply to message #205010] Thu, 23 November 2006 01:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Have you tried it yourself?
If so, paste your code.

By
Vamsi
Re: Procedure [message #205043 is a reply to message #205019] Thu, 23 November 2006 02:36 Go to previous messageGo to next message
arunprabhu29917
Messages: 15
Registered: September 2006
Location: Tamilnadu
Junior Member

Hi,
Since beginner in PL/SQL I have not tried.So plz let me know.

Thanks & Regards,
Arunprabhu
Re: Procedure [message #205130 is a reply to message #205043] Thu, 23 November 2006 07:09 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Basically, you won't need a procedure - it can be done in SQL:
SELECT TO_DATE('&start_date', 'dd.mm.yyyy') + ROWNUM sd
FROM ALL_OBJECTS
WHERE TO_DATE('&start_date', 'dd.mm.yyyy') + ROWNUM <=
      TO_DATE('&end_date', 'dd.mm.yyyy')
Re: Procedure [message #205648 is a reply to message #205043] Sun, 26 November 2006 23:40 Go to previous message
arunprabhu29917
Messages: 15
Registered: September 2006
Location: Tamilnadu
Junior Member

Hi,

Thanks A lot for prompt responce to my query....

Thanks & Regards,
Arunprabhu
Previous Topic: SQL Query for Parent and child relation
Next Topic: how oracle internally manage the sql query?
Goto Forum:
  


Current Time: Tue Dec 06 14:28:58 CST 2016

Total time taken to generate the page: 0.16112 seconds