Re: PLSQL quotes and double quotes

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/05/16
Message-ID: <337d9b10.8188133_at_newshost>#1/1

On Fri, 16 May 1997 13:02:02 -0700, CG <christian.gregory_at_citicorp.com> wrote:

>This is a very simple question: How do we embedded single quotes
>in single quotes when assigning a stringg to a variable ?.
>
>Ex:
>
>string1 VARCHAR2(100) := 'select column1 from table1 where column2 = '5'
>and column3 is null';
>
>Chris

'' = ' in a string....

string1 VARCHAR2(100) := 'select column1 from table1 where column2 = ''5'' and column3 is null';

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri May 16 1997 - 00:00:00 CEST