SELECT CUST_ID, DECODE(CUST_ID,'101',CUST_QUTY) AS CUST

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

Question Posted / subhash

3 Answers
8194 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / subhash

SELECT
CUST_ID,
DECODE(CUST_ID,'101',CUST_QUTY) AS CUST_QUTY1,
DECODE(CUST_ID,'102',CUST_QUTY) AS CUST_QUTY2,
DECODE(CUST_ID,'103',CUST_QUTY) AS CUST_QUTY3
FROM TABLE_NAME
GROUP BY CUST_ID;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the benefits of datastage?

1229

Name the command line functions to import and export the DS jobs?

1136

What are the types of containers?

1209

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3241

Define orabulk and bcp stages?

1113

Which algorithm you used for your hashfile?

1166

What is size of a transaction and an array means in a datastage?

1288

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

787

What is the difference between validated and compiled in the datastage?

1266

What is the purpose of pivot stage?

1155

what is use of SDR function?

5159

what is ds administrator used for?

1154

What are the components of ascential data stage?

1169

What are orabulk and bcp stages?

1110

describe the Steps to confiure a Qlogic switch

2372