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

Differentiate between hash file and sequential file?

1084

What are the different kinds of views available in a datastage director?

1037

Why do we use exception activity in Datastage?

1325

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2116

client know skid info?

2092

How complex jobs are implemented in datstage to improve performance?

1055

Explain the importance of surrogate key in data warehousing?

1201

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2299

Define Data Stage?

1102

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

2074

What is use Array size in datastage

1788

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2276

Demonstrate experience in maintaining quality process standards?

2566

How can you write parallel routines in datastage PX?

1026

How do you run datastage job from the command line?

1102