Re: apostophy porblem in SQL*PLUS

From: Dan Doxtader <ddox_at_servtech.com>
Date: 1996/10/26
Message-ID: <3272156F.64D8_at_servtech.com>#1/1


two apostrophe''s
usually do it

Greg Norris wrote:
>
> How can I [replace|translate] an apostrophy in SQL*PLUS?
>
> for example I want to use the following in a script:-
>
> update atable
> set
> charfield1 = '&TEXT1',
> charfield2 = '&TEXT2'
> where conditions are met.
>
> If The value for &TEXT1 has an apostrophy in it, eg. "bob's dog"
> oracle goes berserk! fails.
>
> I tried to translate it but WOH! it sees the apostroph in the
> text as the end of the string.
>
> Any Ideas greatly appreciated..
>
> Thanks in anticipation
> --
> ________________________________________________________________________> Greg Norris BBus(NTU) PAACS "SMILE" its cheap, fuel efficient
> Programmer. and you're better
> Phone 61 89 466114 Fax 61 89 466487 to look at :- )
> Management Information Service
> Northern Territory University
> DARWIN AUSTRALIA Email: norris_g_at_ntu.edu.au
> ________________________________________________________________________
  Received on Sat Oct 26 1996 - 00:00:00 CEST

Original text of this message