Home » SQL & PL/SQL » SQL & PL/SQL » Columns to Rows(New Rows)
Columns to Rows(New Rows) [message #305355] Mon, 10 March 2008 09:06 Go to next message
hirdeyG
Messages: 2
Registered: March 2008
Junior Member
I have table testrow(date1, date2) with values say '01-jan-2008' and '31-mar-2008'
I want a query to display the missing dates something like this

'01-jan-2008'
'15-jan-2008'
'31-jan-2008'
'01-feb-2008'
'15-feb-2008'
'29-feb-2008'
'01-mar-2008'
'15-mar-2008'
'31-mar-2008'

Thanks
Re: Columns to Rows(New Rows) [message #305357 is a reply to message #305355] Mon, 10 March 2008 09:12 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
And what did you try to achieve the same ?

Regards

Raj
Re: Columns to Rows(New Rows) [message #305364 is a reply to message #305355] Mon, 10 March 2008 09:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please search BEFORE posting.

Regards
Michel
Re: Columns to Rows(New Rows) [message #305381 is a reply to message #305357] Mon, 10 March 2008 10:06 Go to previous messageGo to next message
hirdeyG
Messages: 2
Registered: March 2008
Junior Member
I am trying to achieve the same output based on the dates.


Re: Columns to Rows(New Rows) [message #305389 is a reply to message #305381] Mon, 10 March 2008 10:48 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes and this has been asked and answered many times, just search for "calendar".

Regards
Michel
Previous Topic: Rowcount with dynamic cursor
Next Topic: How many schemas in my bd?
Goto Forum:
  


Current Time: Sat Dec 10 14:32:46 CST 2016

Total time taken to generate the page: 0.04278 seconds