how to get this

[zulu99]

hi all

i have a table , contents of which is something like this

Who
why
when
what
how

above are different rows in the table

Now i wnat all the 5 rows to be displayed as 1 row . how to get this

Thanks

[stecal]

select who||why||when||etc from table;

[zulu99]

What i meant by the question is i want all rows of a table in a column to be displayed on a single row

[adewri]

I did something like this


SQL> create table test1 (Ename varchar2(10));

Table created.


SQL> insert into test1 values('&ENAME');
Enter value for ename: Amar
old 1: insert into test1 values('&ENAME')
new 1: insert into test1 values('Amar')

1 row created.

SQL> /
Enter value for ename: Test
old 1: insert into test1 values('&ENAME')
new 1: insert into test1 values('Test')

1 row created.

SQL> /
Enter value for ename: Why
old 1: insert into test1 values('&ENAME')
new 1: insert into test1 values('Why')

1 row created.

SQL> /
Enter value for ename: David
old 1: insert into test1 values('&ENAME')
new 1: insert into test1 values('David')

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test1;

ENAME
------------------------------
Amar
Test
Why
David

SQL> set lines 2000

SQL> select t3.ename,t2.ename,t1.ename
2 from
3 test1 t1,test1 t2,test1 t3
4 where
5 t1.ename <> t2.ename
6 and
7 t2.ename <> t3.ename
8 and
9 t3.ename <> t1.ename
10 and rownum < 2;

ENAME ENAME ENAME
------------------------------ ------------------------------ ------------------------------
Amar Test Why



Other method would be to use PL/SQL procedure...

HTH