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

How one source columns or rows to be loaded in to two different tables?

674

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

992

What are transforms and what is the differenece between routines and transforms?

627

What a datastage macro?

650

Is the value of staging variable stored temporarily or permanently?

589

What is merge stage?

777

How to RD using transformer?

876

What is the purpose of interprocessor stage in server jobs?

1739

Why we use surrogate key?

710

What are routines in datastage? Enlist various types of routines.

643

What is job control?

637

Describe stream connector?

843

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1628

If you want to use a same piece of code in different jobs, how will you achieve this?

809

what is 'reconsideration error' and how can i respond to this error and how to debug this

2127