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 database table in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to write date and time literals in oracle?
What is the maximum limit on the number of columns in a table?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to export data to a csv file?
What is hot backup and logical backup?
candidate key is subset of super key but not vice-verse explain
How to upsert (update or insert into a table)?
Where do you use decode and case statements?
What is user managed backup in Oracle?
What's dateware house and what's clustor with practicle example
What privilege is needed for a user to insert rows to tables in another schema?
Can I create users through internet explorer in oracle 10g?
What are transaction isolation levels supported by oracle?