Home » SQL & PL/SQL » SQL & PL/SQL » Displying data
Displying data [message #233300] Wed, 25 April 2007 10:23 Go to next message
Messages: 110
Registered: June 2005
Location: Pune
Senior Member

I have 5 ROWS OF data

No Id name date1 date2 DESC

A 1 test 2007-04-22 2007-04-25 'Is'
A 2 test 2007-04-26 2007-04-29 'this'
A 3 test 2007-04-29 2007-04-30 'oracle '
A 4 test 2007-04-30 2007-05-20 'question'
A 5 test 2007-05-21 2008-02-20 '?'

I need OUT put like

Col1 col2 col3 col4 col5 col5
A (1,2,3,4,5) 'test 'MIN(date1) MAX(date2) 'IS this oracle question?'

Can anyone help me?

Thanks in advance for any kind of help.
Re: Displying data [message #233301 is a reply to message #233300] Wed, 25 April 2007 10:30 Go to previous message
Michel Cadot
Messages: 64956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read http://www.orafaq.com/forum/t/59964/102589/ and edit your post to format it correctly.
In addition, post the result you really want instead of this "A (1,2,3,4,5) 'test 'MIN(date1) MAX(date2) 'IS this oracle question?'" which mixed data and metadata. For instance, does A must appear in the result? And the parenthesis? etc.

Don't forget your Oracle version.


[Updated on: Wed, 25 April 2007 10:30]

Report message to a moderator

Previous Topic: Identifier Too Long
Next Topic: REFRESH COMPLETE ON DEMAND materialized view
Goto Forum:

Current Time: Tue Jun 27 00:35:51 CDT 2017

Total time taken to generate the page: 0.27930 seconds