how to use Oracle decode Select statment
SELECT DECODE(SEND_BEN_INFO1_7495_1,'YOUR UTR SBINH13246802674
RTN',(REPLACE(REPLACE('YOUR UTR SBINH13246802674 RTN','YOUR
UTR',''),'RTN','')),'Null')"UTR" FROM NT_N06 where value_dt='20121214' and
MSG_SUMMARY_ID=181521. This is not working? How can use select statement
with in decode function.
No comments:
Post a Comment