select translate('1,101;1,102;1,103','1,101;1,102;1,103'

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 / srinu

Answer Posted / srinu

select translate('1,101;1,102;1,103','1,101;1,102;1,103',1
101,102,103) from dual;

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Why fact table is in normal form?

1147

Give an idea of system variables.

962

How you Implemented SCD Type 1 & Type 2 in your project?

4072

What are constraints and derivations?

1111

Why do we use link partitioner and link collector in datastage?

1073

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1190

What is the purpose of pivot stage?

1095

What is datastage?

1028

What is difference between symmetric multiprocessing and massive parallel processing?

1078

What is quality stage?

937

Why do we use exception activity in Datastage?

1226

How to implement complex jobs in data stage?

1049

Which commands are used to import and export the datastage jobs?

1358

Can you implement SCD2 using join, transformer and funnel stage?

1495

How to read the length of word in unix?

1310