Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple SQL question

Re: Simple SQL question

From: SteveC <stevec_at_sfsu.edu>
Date: 3 Feb 2006 16:15:20 -0800
Message-ID: <1139012120.086528.94190@g43g2000cwa.googlegroups.com>


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

Received on Fri Feb 03 2006 - 18:15:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US