Sql Select

oracle

TO_CHAR Oracle Function

With the function TO_CHAR, Oracle converts a number or date to a string. The to_char Oracle syntax is: to_char( value, […]

oracle

SQL: Remove Strings or Letters

Remove: select TRANSLATE(’12A3′,‘0123456789’, ‘ ‘) FROM dual or   select LTRIM(RTRIM(TRANSLATE(UPPER(’12a’), ABCDEFGHIJKLMNOPQRSTUVWXYZ’, ‘ ‘))) as nr , LTRIM(RTRIM(TRANSLATE(UPPER(’12a’),‘0123456789’, ‘ ‘)))

Scroll to Top