Home » SQL & PL/SQL » SQL & PL/SQL » Date range SQL CURSOR
Date range SQL CURSOR [message #336164] Fri, 25 July 2008 01:29 Go to next message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
Hi,
I want print from first date to last date of the given month using cursor, where user will i/p first date and end date.
Re: Date range SQL CURSOR [message #336182 is a reply to message #336164] Fri, 25 July 2008 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why using cursor?
Have a look at datetime functions

Regards
Michel
Re: Date range SQL CURSOR [message #336261 is a reply to message #336164] Fri, 25 July 2008 08:06 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Hint: CONNECT BY
Re: Date range SQL CURSOR [message #336265 is a reply to message #336164] Fri, 25 July 2008 08:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also search for "calendar".

Regards
Michel

P.S. isn't it the second time I post this today?
Re: Date range SQL CURSOR [message #336269 is a reply to message #336265] Fri, 25 July 2008 08:25 Go to previous message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Quote:
isn't it the second time I post this today?
Only the second time. I'm surprised it's not more. Wink
Previous Topic: UTL_FILE and creating DIRECTORIES
Next Topic: INSERT statement (no error, but not working?)
Goto Forum:
  


Current Time: Sun Dec 11 00:22:53 CST 2016

Total time taken to generate the page: 0.05853 seconds