Home » SQL & PL/SQL » SQL & PL/SQL » SQL qry doubt ...
SQL qry doubt ... [message #187708] Tue, 15 August 2006 01:50 Go to next message
Messages: 162
Registered: February 2006
Senior Member
Hi pals,

Can anyone pls hel me out. I want qry such that it dislays rows as columns in the output.Something like crosstab reports.
Can we do that.

Example my table name is sample.

create table samle(id number,name varchar2(20),sal number);

insert into sample values(1,'zach',9000);
insert into sample values(2,'raj',4000);
insert into sample values(3,'sam',5000);

now i want to display my outut as follows:
1 2 3
zach raj sam
9000 4000 5000

pls help me out.

Thanks in Advance.
Re: SQL qry doubt ... [message #187713 is a reply to message #187708] Tue, 15 August 2006 02:05 Go to previous message
Messages: 48
Registered: July 2006
See the FAQ
Previous Topic: Getting error 'ORA-01756: quoted string not properly terminated'
Next Topic: pls
Goto Forum:

Current Time: Fri Oct 21 19:22:15 CDT 2016

Total time taken to generate the page: 0.09111 seconds