ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ?
- 4 Answers
- 7148 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
What is an oracle wallet?
How to load data through external tables?
How to create lov dynamically at runtime & attach to text field?
What is Trigger in Oracle?
How to estimate disk space needed for an export job?
What are the uses of a database trigger?
How to enter a new row into a table interactively?
how to make an oracle object
How to create a stored procedure in oracle?
How to define an anonymous procedure with variables?
Design database draw er diagram for a certain scenario ?
How to create a new user account in oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is private procedure oracle?
What is a static data dictionary in oracle?
