replace function [message #296621] |
Mon, 28 January 2008 07:37  |
ishika_20
Messages: 339 Registered: December 2006 Location: delhi
|
Senior Member |
|
|
hello
sir i want to replace 24 by 'C'.
SQL> ED
Wrote file afiedt.buf
1 SELECT VC_ITEM_CODE FROM MAKESS.MST_ITEM
2* WHERE VC_ITEM_CODE LIKE '24TPXXCTXX00075900200000'
SQL> /
VC_ITEM_CODE
------------------------------
24TPXXCTXX00075900200000
24TPXXCTXX00075900200000
24TPXXCTXX00075900200000
please tell me how could i replace.
waiting for your reply
thanking you
|
|
|
|
|
|
Re: replace function [message #296652 is a reply to message #296647] |
Mon, 28 January 2008 09:34   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
sudhaputtagunta wrote on Mon, 28 January 2008 15:53 | Try this
SELECT replace(VC_ITEM_CODE,substr(VC_ITEM_CODE,1,2),'c')
FROM MAKESS.MST_ITEM
WHERE VC_ITEM_CODE LIKE '24TPXXCTXX00075900200000'
|
Would this not be much easier?
select 'C'||substr(vc_item_code, 3)
from ...
It does exactly the same
|
|
|
Re: replace function [message #296680 is a reply to message #296652] |
Mon, 28 January 2008 11:49  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
OrSELECT REPLACE('24TPXXCTXX00075900200000', '24', 'c') result FROM dual orSELECT REGEXP_REPLACE('24TPXXCTXX0007590020000024', '24', 'c', 1, 1) result FROM dual;
|
|
|