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
7708 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 is an Oracle Instance?

1067

How do you bind variables in oracle?

927

How to drop a tablespace?

981

How to establish administrator authentication to the server?

981

How to assign values to data fields in record variables?

970

How to create a table interactively?

995

What is oracle host variable?

978

What is SQL Tuning Advisor in Oracle?

1105

What is a cognitive schema?

905

How to login to the server without an instance?

1100

What are the advantages of oracle?

960

What privilege is needed for a user to connect to oracle server?

937

what is the scenario where you take the database to NoArchivelog mode?

2256

What is the difference between 10g OEM and 11g OEM?

916

Why do you use stored procedures and state some of its disadvantages?

967