Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple SQL question
TRANSLATE does single-character transliterations, and ALSO replaces
characters with null.
Using the translate solution would have removed ALL spaces, and the result would be 'thecatsatonthemat'
I use translate often to verify that an input field ONLY contains numeric digits:
If translate(v_var1,'A0123456789','A') is not null then