ex. one table is having 1 column with 10 records , then how to display all the

ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ?

Question Posted / patilshashi

4 Answers
7132 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?..

Answer / dinesh a.

create table x (col1 number(4));
insert into x value(1);
....
...
insert into x value(10); /* upto 10 rows

then

select
substr(max(decode(rownum,1,col1,0)),1,2),
substr(max(decode(rownum,2,col1,0)),1,2),
substr(max(decode(rownum,3,col1,0)),1,2),
substr(max(decode(rownum,4,col1,0)),1,2),
substr(max(decode(rownum,5,col1,0)),1,2),
substr(max(decode(rownum,6,col1,0)),1,2),
substr(max(decode(rownum,7,col1,0)),1,2),
substr(max(decode(rownum,8,col1,0)),1,2),
substr(max(decode(rownum,9,col1,0)),1,2),
substr(max(decode(rownum,10,col1,0)),1,2)
from x

(where substr only to reduce display size )

Is This Answer Correct ?

2 Yes

2 No

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?..

Answer / ajit

select wm_concat(rel)
from UPDATE_TEST

Is This Answer Correct ?

0 Yes

0 No

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?..

Answer / ruchi varma

it will need a cursor.

begin
for cur1 in (select a from Name) loop
dbms_output.put(cur1.a);
end loop;
end;

dbms_output.put -> displays a chr without putting a new line

Is This Answer Correct ?

0 Yes

1 No

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?..

Answer / vipul

column can be convert in row by using PIVOT function in ORACLE

for eg:

SELECT * FROM(SELECT VMENUNAME,NMENUNO FROM MENU_MASTER) A
PIVOT(MAX(VMENUNAME) FOR NMENUNO IN (6,7,8,9,10,11,1)) PVT

Is This Answer Correct ?

0 Yes

3 No

Post New Answer