Interested to Buy Any Domain ? << Click Here >> for more details...
ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ?
- 4 Answers
- 8048 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
How to grant create session privilege to a user in oracle?
Compare and contrast between sql and sql server and explain its various functions?
Explain about achiever in sql?
Explain the difference between replace() and translate() functions in oracle?
How do you find current date and time in oracle?
How to create a stored program unit?
does the query needs a hint to access a materialized view?
What is the usage of synonyms?
How to use windows user to connect to the server?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain the use of Merge statement in oracle 11g
what are bitmap indexes? How does they work?
Explain what are the uses of rollback segment?
How many types of tables are there in oracle?
What is sequence?
