Re: Invalid characters in a string

From: Boogie <boogie_at_boogie-the-cat.demon.co.uk>
Date: Fri, 11 Feb 2000 21:34:52 -0000
Message-ID: <950305308.27771.0.nnrp-06.d4e46045@news.demon.co.uk>

Hi Connor,

Would "escaping" the character help, - cant test it cause tooooo lazy to walk down stairs to turn on the Solaris machine !

Boogie
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:38A40083.3052_at_yahoo.com...
> Patrick Joyal wrote:
> >
> > What are the invalid characters (in string values) that I should watch
for
> > where I'm constructing SQL String?
> >
> > I know there's ' that I can replace with ''
> > but I'm having problem with ;
> >
> > thanks
> >
> > Patrick
>
> ';' is not a problem character in the db, its just that its a problem
> character in SQL Plus...
>
> In SQL Plus, do
>
> SQL> show all
>
> and you can see what characters are going to be important
>
> HTH
> --
> ===========================================
> Connor McDonald
> There are 3,434,679 oracle websites around the world.
> Now there is one more... http://www.oracledba.co.uk
Received on Fri Feb 11 2000 - 15:34:52 CST