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 odbc and drs stage?

1104

What are the different plug-ins stages used in your projects?

1126

What is apt_config in datastage?

1197

What is the difference between passive stage and active stage?

1649

Is the value of staging variable stored temporarily or permanently?

1056

Differentiate between data file and descriptor file?

1107

How you can fix the truncated data error in datastage?

1888

EXPLAIN SCD

1450

What is difference between symmetric multiprocessing and massive parallel processing?

1200

What is a merge?

1241

AGGREGATOR default datatype

1526

Enlist various types of routines in datastage.

1328

what is use of SDR function?

5225

describe the Steps to confiure a Qlogic switch

2439

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

3296