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
The Boy's shirt
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 *