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 load last n records of file into target table - informatica

0 Answers   Informatica,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

Explain grouped cross tab?

1 Answers   Accenture,

---

---

Where is metadata stored?

0 Answers  

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

---

How the facts will be loaded? explain

2 Answers   HCL,

---

what is the gap analysis?

1 Answers  

---

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

---