oracle functions
<br /><br />SELECT decode(T.CHANNEL,'E','SWIFT','M','MANUAL') AS CHANNEL FROM TABLE_NAME T WHERE T.STATUS_CD = '01';<br /> <br />SELECT NVL(T.OFFICER1,'SYSTEM') AS OFFICER FROM TABLE_NAME T WHERE T.STATUS_CD = '01';<br /> <br />SELECT LENGTH(T.OPER_ID) FRO
复制链接