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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle isalpha() function?

Re: Oracle isalpha() function?

From: Tom Verhagen <tverhage_at_aon.nl>
Date: Wed, 24 Nov 1999 15:20:38 +0100
Message-ID: <383BF436.486588D4@aon.nl>


you can use translate function as well, like

  1* select translate (lower('&1'),'abcdefghijklmnopqrstuvwxyz',' ') from dual

returns fe for the charachter E a space (' ') and for a number 1 returns '1' Received on Wed Nov 24 1999 - 08:20:38 CST

Original text of this message

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