[PHP]
SQL> select * from t_per;
PERNAMEREVPERNA
-------- --------
abcd dcba
Elapsed: 00:00:00.00
SQL> select decode(substrb(pername,1,2),'ab','yi'||ltrim(pername,'ab'),pername),
2 decode(substrb(revpername,-2,2),'ba',rtrim(revpername,'ba')||'iy',revpername)
3from t_per;
DECODE(SUBST DECODE(SUBST
------------ ------------
yicd dciy
Elapsed: 00:00:00.00
SQL>
[/PHP]
|