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