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: 65155
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: Writing to a file from PL/SQL procedure
Next Topic: Max Query Help!!!
Goto Forum:

Current Time: Thu Aug 24 00:12:39 CDT 2017

Total time taken to generate the page: 0.01690 seconds