Re: ESCAPE SYMBOL

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Mon, 26 Jul 1999 16:35:49 GMT
Message-ID: <379e8e15.16212342@inet16.us.oracle.com>

On Mon, 26 Jul 1999 18:35:33 +0200, "Diego Peroni" <peroni_at_cefriel.it> wrote:

>Anyone knows how is possible to run a correct INSERT like this?
>
>INSERT INTO workspacename.tablename VALUES (
>'D'Amico Andrea'
>);

try:

INSERT INTO workspacename.tablename
VALUES ( 'D''Amico Andrea' );

chris.

>
>When I put special symbol like this: ' Oracle thinks that the string is
>finish and do not process the statement!
>
>Thanks
>Diego Peroni
>
>

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jul 26 1999 - 11:35:49 CDT