OraFAQ Forum: Server Administration » how to enter 'a&b' in varchar field?

Home » RDBMS Server » Server Administration » how to enter 'a&b' in varchar field?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to enter 'a&b' in varchar field? [message #115153]

Thu, 07 April 2005 14:32

win_vj
Messages: 16
Registered: March 2005
Location: India

Junior Member

Hi All,

I have a table which contains a varchar field. I have to enter a value in that field let say 'a&b', But oracle is taking it as a variable and asks to enter value for '&b'.

SQL> desc test1
Name Null? Type
----------------------------------------- -------- ------------
FNAME VARCHAR2(10)
LNAME VARCHAR2(10)
AGE NUMBER(3)

SQL> Insert into test1(FNAME,LNAME,AGE) values('a&b','b&a',20);

How can i enter a&b in these fields?

Thanks in Advance!
WIN

Report message to a moderator

Re: how to enter 'a&b' in varchar field? [message #115154 is a reply to message #115153]

Thu, 07 April 2005 14:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

mag@mutation_mutation > set escape '/'
 mag@mutation_mutation > insert into tableA values ('A/&B')
  2  /

1 row created.

mag@mutation_mutation > select * from tableA;

C
----------
A&B

Report message to a moderator