using the anydata datatype in oracle
——————————————————————————– — sys.anydata.sql ——————————————————————————– — Using the ANYDATA object — Startin with Oracl9i and up, ANYDATA is described — by […]
——————————————————————————– — sys.anydata.sql ——————————————————————————– — Using the ANYDATA object — Startin with Oracl9i and up, ANYDATA is described — by […]
Remove: select TRANSLATE(’12A3′,‘0123456789’, ‘ ‘) FROM dual or select LTRIM(RTRIM(TRANSLATE(UPPER(’12a’), ABCDEFGHIJKLMNOPQRSTUVWXYZ’, ‘ ‘))) as nr , LTRIM(RTRIM(TRANSLATE(UPPER(’12a’),‘0123456789’, ‘ ‘)))