Re: apostophy porblem in SQL*PLUS
From: Gary Assa <gsa_at_li.net>
Date: 1996/11/04
Message-ID: <55ktie$3l3_at_linet01.li.net>#1/1
Date: 1996/11/04
Message-ID: <55ktie$3l3_at_linet01.li.net>#1/1
>update atable
> set
> charfield1 = '&TEXT1',
> charfield2 = '&TEXT2'
> where conditions are met.
>
put a double apostrophe when entering the data as such:
Pete''s Wicked Ale
-- ========================================================= http://www.li.net/~gsa/index.html This is my signature file, not part of this mail message.Received on Mon Nov 04 1996 - 00:00:00 CET