Re: SQL*plus and '

From: Maggie Shapland <Maggie.Shapland_at_bristol.ac.uk>
Date: 1996/02/09
Message-ID: <DMIpu5.G3A_at_uns.bris.ac.uk>#1/1

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

double up the ' eg select 'fred''s cat'

-- 
Maggie.Shapland_at_bristol.ac.uk 
Computing Service,University of Bristol,Tyndall Avenue, Bristol 
BS8 1UD
Tel: 0117 9289000 Ext 3229 Fax: 0117 9291576
http://www.bris.ac.uk/~ccmjs

Received on Fri Feb 09 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Michael Abbey: "Re: Optimizer: Rules-based going away? When?"
Previous message: Mungo Henning: "Re: [?] sqlplus error"
In reply to: Roman L. Podshivalov: "SQL*plus and '"
Next in thread: Michael Abbey: "Re: Optimizer: Rules-based going away? When?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message