Re: Functions

On Mar 23, 11:33 am, DA Morgan <damor...@xxxxxxxxx> wrote:
kraji...@xxxxxxxxx wrote:
Hi

How to identify special characters in a string ?

what is the function

Appreciate u r help
Thanks
Sistla

What version of Oracle?
What special characters?

My first thought would be regular expressions:
Morgan's Library atwww.psoug.org
Look up Regular Expressions

If that doesn't work consider ASCII and CHR functions
and more work.
--
Daniel A. Morgan
University of Washington
damor...@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org

Thanks a lot

.

Relevant Pages

  • Re: Search Replace String function
    ... In this case regular expressions will be the best way. ... You could use a stored Java procedure to do the parsing/replacing (no ... Daniel A. Morgan ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.misc)
  • Re: Performance of REGEXP_LIKE vs LIKE?
    ... You write that "Regular expressions are implemented using Java. ... force Oracle to call Java, ... The delay would be ...
    (comp.databases.oracle.misc)
  • Re: Performance of REGEXP_LIKE vs LIKE?
    ... You write that "Regular expressions are implemented using Java. ... force Oracle to call Java, ... caused by the architecture." ...
    (comp.databases.oracle.misc)
  • Re: Question about Sun JAVAC
    ... > The RE and ERE syntax used by various Unix utilities clearly was ... > Of course the symbols available for ASCII I/O devices (that is, ... > But traditional mathematical syntax for regular expressions happened ...
    (comp.programming)
  • Access, Oracle and Special Characters
    ... I have linked an an Oracle 9.2 table with Access 2000 via ... The tabel consists of two VARCHAR2 fields. ... Datasets without special characters ...
    (microsoft.public.access.externaldata)
Loading