ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ?
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
What is a synonym? What are its various types?
How to use "if" statements on multiple conditions?
What is a system tablespace and when it is created?
What are the differences between char and varchar2 in oracle?
Which is better Oracle or MS SQL? Why?
How to start your 10g xe server from command line?
How do we get field details of a table?
Explain integrity constraint?
How to list all indexes in your schema?
What is format trigger?
What is Redo Log Buffer in Oracle?
What would you do with an in-doubt distributed transaction?
What are the restrictions on external table columns?
What are the attributes of cursor?
Explain the use of record length option in exp command.