Quote Originally Posted by thomasp
Like Davey said, in sqlplus, you can use set define off

Otherwise, you can use '\' character to escape.

eg:

insert into test_table values ('C\&G');
Doesn't work for me

Code:
SQL> create table g (col1 varchar2(30));

Table created.

SQL> insert into g values ('C\&G');
Enter value for g: ?
old   1: insert into g values ('C\&G')
new   1: insert into g values ('C\?')

1 row created.

SQL> select * from g;

COL1
------------------------------
C\?