display table row into column

I have :

SQL> create table t1( col1 varchar2(10), col2 varchar2(10),col3 varchar2(10));

Table created.

SQL> SQL> insert into t1(col1,col2,col3) values ('A','B','C');

1 row created.

SQL> insert into t1(col1,col2,col3) values ('D','E','F');

1 row created.

SQL> insert into t1(col1,col2,col3) values ('G','H','I');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t1;

COL1 COL2 COL3
---------- ---------- ----------

A          B          C
D          E          F
G          H          I

i want to write select query which should give me the output: as

col1 col2 col3

----     ------    ------
B       E        H

Regards

Shweta Received on Thu Feb 26 2009 - 06:48:54 CST