cust id,cust quty like 1,101;1,102;1,103 i want output like
cust id,cust quty 1 101,102,103 in oracle please write a
query in oracle
Answer Posted / subhash
PIVOT finction available from ORCLE 11g Onwards:
SELECT *
FROM (SELECT customer_id, customer_quantity
FROM pivot_test)
PIVOT (customer_quantity FOR (customer_quantity
) IN (101, 102, 103))
ORDER BY customer_id;
Output:
1 101 102 103
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How will you move hashed file from one location to another location?
What is a folder? Difference types of stages?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How to RD using transformer?
How many types of sorting methods are available in datastage?
which r the connectors used in san?
Define Routines and their types?
Define data aggregation?
what is the use of surogate key in datastage
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Where do you see different stages in the designer?
How to implement complex jobs in data stage?
What is the difference between the local container and shared container?
How to read the length of word in unix?