Answer / rathnakumar

select replace('111111111111ravi11111111kumar11111111111','1','') from dual;

Answer / jvdwhinfo

You are absolutely right Rathnakumar.
But we can also get the output by writing the query as
follows:
select replace('11111111ravi111111kumar11111',1,null) from
dual;
Anymore suggestions please let me know guys.

Thanks.
James

Answer / murali

In expr_trns we can use---

REPLACECHR (
1, "111111111111ravi11111111kumar11111111111" , '1', NULL)


Thanks,
Murali Udayagiri

How to Create a folder using pmrep command?

0 Answers  

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

How can you increase the performance in joiner transformation?

0 Answers  

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

What is the function of union transformation?

0 Answers  

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

What is workflow manager?

0 Answers  

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---

What is difference between maplet and reusable transformation?

2 Answers  

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

Enlist the differences between database and data warehouse.

0 Answers  

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---