CONVERSION. [message #21745] |
Tue, 27 August 2002 08:52 |
masoom
Messages: 2 Registered: November 2001
|
Junior Member |
|
|
hello experts!
actually i want to see my data from THE ENAME OF 'emp' as the first 'A' from emp coverts as 'X' and the second ename from the emp converts as 'XX'. for example
ename converted_value
ADAMS XDXXMS
ALLEN XLLEN
MARTIN MXRTIN.
IT IS VERY URGEN PLS HELP ME.
BEST REGARDS
MASOOM.
|
|
|
Re: CONVERSION. [message #21751 is a reply to message #21745] |
Tue, 27 August 2002 22:34 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
hi,
the following query solves u'r problem if u have character 'A' upto second occurence in ename column.
select replace(decode(nvl(substr(ename,1,instr(ename,'A',1,2)),'1'),'1',ename,substr(ename,1,instr(ename,'A',1,2)-1)),'A','X')||
replace(substr(ename,decode(instr(ename,'A',1,2),0,null,instr(ename,'A',1,2)),length(ename)),'A','XX') from emp
bye,
raj
|
|
|