This is probably a simple noob-type question, but I don't have any SQL/Oracle books with me......what's the escape character in Oracle?

I'm trying to insert a record with a value of 'Sterile Fill (B&S)' but it looks like the ampersand is causing a problem.

Any suggestions appreciated.

set define off

Escape characters are those which have to be speciallly handled .
comma, double quotes , & are escape characters

cyrus

Following is another method using escape on

SQL> show escape define
escape OFF
define "&" (hex 26)
SQL> insert into test values('A & A');
Enter value for a: a
old 1: insert into test values('A & A')
new 1: insert into test values('A a')

1 row created.

SQL> set escape on
SQL> insert into test values('A \& A');

1 row created.

Thanks The_Duck! That was the quickest easiest solution for me to use. You da fowl!!!!

Also, thanks arvindl for reminding me of the '\' as that's what I was looking for. The 'set define off' just saves me from editing the code.