Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 8195 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Why fact table is in normal form?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Explain the importance of surrogate key in data warehousing?
What is the use of hoursfromtime() function in transformer stage in datastage?
How a routine is called in datastage job?
What is the difference between orabulk and bcp stages?
What is the process of killing a job in datastage?
how to delete one row in target dataset
How do you import and export the datastage jobs?
What is the different type of jobs in datastage?
Name the different sorting methods in datastage.
why do u need the IOS upgradation in a FC switch
How many types of sorting methods are available in datastage?
How to manage date conversion in Datastage?
