Re: inserting single qutoes in string???

From: Amir M. Farhi <phantom_at_math.tau.ac.il>
Date: 1996/03/28
Message-ID: <315B5471.2873_at_math.tau.ac.il>#1/1


Allan Marcus wrote:
>
> is there a way (from sql*plus) to insert a single quote in a varchar field?
> This is, of course, a problem since the single quote usually delimits a string.
>
> Thanks,
>
> Allan Marcus
> "My opinions are my own, I think..."
>
> AppleLink: Allan.Marcus
> CIS: go ATOMIC, section 7
> InterNet: Atomic.Software_at_pobox.com
> eWorld or NewtonMail: Allan.M
> AOL: Atomic.Software_at_pobox.com
> Day Job email: allan_marcus_at_lanl.gov
> Day Job Voice: 505-665-1828
> Home Voice: 505-672-0370
> -------------------------------------------------

Look at the following example:

SQL> Select '''' from dual;

'
-
'

SQL> select 'The Boy''s shirt' from dual;

'THEBOY''SSHIRT



The Boy's shirt

Good Luck
Amir


  • Amir M. Farhi *
  • Oracle consultant *
  • *
  • Office: Home: *
  • John Bryce (Systems) 1984 Ltd. 4 Yochanan Hagadi St., *
  • 35 Jabotinski St., Tel-Aviv 62269 *
  • Ramat-Gan 52511 I S R A E L *
  • I S R A E L TeleFax: 972-3-5445458 *
  • Phone: 972-3-5765660/6 Mobile: 972-52-450424 *
  • Fax: 972-3-6131175 e-mail: phantom_at_math.tau.ac.il *
  • e-mail: afarhi_at_il.oracle.com (Tel-Aviv University) *
  • visit my WWW home page at http://www.math.tau.ac.il/~phantom *
Received on Thu Mar 28 1996 - 00:00:00 CET

Original text of this message