Re: SQL*plus and '

Roman L. Podshivalov wrote:
>
> Can any 1 tell me how to insert field with ' through SQL*Plus ???

You need to put 2 ' for every 1 you want to print:

  insert into temp (testval) values ('Isn''t that something...');

Jerry.

Jerry Bull, Sr. MTS             Phone: 303-624-3073
U S WEST Technologies           Fax:   303-624-8462
931 14th Street, Suite 920      E-mail: gbbull_at_uswest.com