display rows beside each-other

From: Ronald <rmoleveld_at_hotmail.com>
Date: 15 Apr 2005 03:18:06 -0700
Message-ID: <1113560286.548368.295880@z14g2000cwz.googlegroups.com>

Hi all,

A simplified example of my question.

Normally this query:

select name
from emp
where rownum <3

will result in:

NAME

---

Johnson
Smith

but Im looking a way to get this as result:

Johnson Smith

With or without the heading, doesn't matter.

Is there a way to achieve this ?

Thanks in advance !!

Ronald. Received on Fri Apr 15 2005 - 05:18:06 CDT