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: put away characters in result of query

Re: put away characters in result of query

From: T <t_at_yahoo.com>
Date: Fri, 23 Dec 2005 12:11:53 +0100
Message-ID: <dogm31$d1h$1@ss405.t-com.hr> 





i heard


regexp_replace(field1,'[:alpha:]','')


exist only on 10g not privious version of oracle (eg 9.2.01)



"Carlos" <miotromailcarlos_at_netscape.net> wrote in message 
news:1135335647.298272.75090_at_g49g2000cwa.googlegroups.com...


> Take a look at TRANSLATE function.

>

> Also, you might want to create a hand-made function that fulfills your

> requirements if needed.

>

> Cheers.

>

> Carlos.

> 

Received on Fri Dec 23 2005 - 05:11:53 CST












Original text of this message













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