Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 8188 Views
- TCS, I also Faced
- E-Mail Answers
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
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the command line function to import and export the ds jobs?
How many areas for files does datastage have?
Can you implement SCD2 using join, transformer and funnel stage?
Is it possible to query a hash file?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Can you explain engine tier in information server?
What are the different options associated with dsjob command?
Notification Activity
Highlight the main features of datastage?
What is aggtorec restructure operator?
Differentiate between datastage and informatica?
What are stage variables, derivations and constants?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
