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
Answers were Sorted based on User's Feedback
Answer / 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 |
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
how can u connect the client system directly at any time?
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
what is a nodemap constraint
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What are the enhancements made in datastage 7.5 compare with 7.0?
how can we join one oracle & flat files ?
how to add a new records into source?
How to convert RGB Value to Hexadecimal values in datastage?
What is a ds designer?
How do you load 10 different sources with 10 different layouts to 10 different tables?
Differentiate between Join, Merge and Lookup stage?