Sql to display output in Horizontal view
814929Sep 8 2012 — edited Sep 8 2012Experts,
I need to display the sql query output in horizontal manner. Below I have given the script.
create table TestTable (id number, name varchar2(10))
insert into TestTable values (1, 'John')
insert into TestTable values (2, 'Mckensy')
insert into TestTable values (3, 'Valneech')
insert into TestTable values (4, 'Zeebra')
commit
select * from TestTable
Getting output in Vertical View.
ID Name
1 John
2 Mckensy
3 Valneech
4 Zeebra
But for my requirement, I need to display in horizontal manner.
ID 1 2 3 4
Name John Mckensy Valneech Zeebra