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
- 7930 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 list all user accounts in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is a synonym? What are its various types?
What are the parameters that we can pass through a stored procedure?
In which language oracle has been developed?
What is clustered table in Oracle?
How do I know if oracle client is installed on windows?
What is a tns service name?
What is oracle update statement with inner join ?
How many types of segments in Oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is an index associated with a constraint?
What is the implicit cursor in oracle?
does the query needs a hint to access a materialized view?
How to create a table index?
