column can be convert in row by using PIVOT function in ORACLE for eg:

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

Question Posted / vipul

4 Answers
8031 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What are the ways tablespaces can be managed and how do they differ?

2440

What is set operator oracle?

1034

What is the order of defining local variables and sub procedures/functions?

1112

What privilege is needed for a user to create views in oracle?

1091

What is connection pool in oracle?

1033

How do I spool to a csv formatted file using sqlplus?

1083

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1157

What is Trigger in Oracle?

1238

How to bring a tablespace offline?

1112

What is a procedure in oracle?

1278

Why is oracle so popular?

1051

How to see the table columns used in an index?

1070

What is set verify off in oracle?

1153

What is the sid in oracle?

1032

How to use "out" parameter properly?

1121