Re: SQL*plus and '

In article <4f5apo$6pu_at_oz.frb.ru> romas_at_pb.frb.ru (Roman L. Podshivalov) writes:

   From: romas_at_pb.frb.ru (Roman L. Podshivalov)    Newsgroups: comp.databases.oracle
   Date: Mon, 05 Feb 1996 14:31:06 GMT
   Organization: PB FRB
   Reply-To: romas_at_pb.frb.ru
   Path: sbctri.tri.sbc.com!newspump.wustl.edu!news.ecn.bgu.edu!vixen.cso.uiuc.edu!newsfeed.internetmci.com!primus.ac.net!news.serv.net!solaris.cc.vt.edu!news.mathworks.com!uunet!in1.uu.net!nntp.path.net!sovam!oz.frb.ru!news    Lines: 2
   NNTP-Posting-Host: bruchmula.pb.frb.ru    X-Newsreader: Forte Free Agent 1.0.82

> Can any 1 tell me how to insert field with ' through SQL*Plus ???

try: insert into table values('Mr. Smith''s stuff');  

-- 

  +----------------------+----------------------------------------------+
  | David Rackley        | email: drack_at_tri.sbc.com                     |
  | Southwestern Bell    |   tel: (512) 372-5516  FAX: (512) 372-5591   |
  | Technology Resources |  http://www.tri.sbc.com/                     |
  | 9505 Arboretum Blvd  +----------------------------------------------+
  | Austin, TX 78759     | It's OK to be a martyr, as long as you don't |
  |                      | bring your own firewood.  -- Dr. Jim Rigby   |
  +----------------------+----------------------------------------------+