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
7903 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

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

How to assign a tablespace to a users in oracle?

1048

Write a syntax for update query in oracle?

1034

How do you store pictures in a database?

1006

how to handle exceptions in post production

1426

Why do we need oracle client?

949

How to use subqueries with the exists operator in oracle?

1027

How can I combine multiple rows into a comma-delimited list in oracle?

1062

Why is oracle so popular?

997

How to call a stored function in oracle?

1018

How to use existing values in update statements using oracle?

1067

How to create a single index for multiple columns?

1037

State and explain about oracle instance?

991

what are archived logs?

2199

How to start your 10g xe server?

1041