escape character???

From: Zhao Fu <scip6125_at_leonis.nus.edu.sg>
Date: 26 Dec 1998 18:03:54 GMT
Message-ID: <7638ea$6i7$1@nuscc.nus.edu.sg>

I am inserting a string which contains single quotation marks to a VARCHAR2 type column, the string is like 'be in('1','2')'

In SQL*PLUS, I set the escape character to '\', so my SQL statement is like this:

insert into test_a_spec
(action,condition)
values('be', 'be in (\'1\',\'2\')');

But I still got the error:

'be in ('1','2')'

*
ERROR at line 4:
ORA-00917: missing comma

Could anyone point me a direction to solve the problem?

Thank you in advance.
--
Zhao Fu Received on Sat Dec 26 1998 - 12:03:54 CST