inserting records

From: Motley Crue, Vaxxer <chuacl_at_iscs.nus.sg>
Date: 1997/02/11
Message-ID: <5dombj$54s@nuscc.nus.sg>#1/1

When I tried to insert a record contains a '&' character into a varchar2 datatype column, it will prompt me for the value of string that appears after the & char, eg record is "t & t1"

After I entered the insert sql statement, I'll get the following Enter value for t1:
#after I pressed enter
old : insert ....... values("t & t1")
new : insert ....... values("t & ")

Tried to put to a backslash in front of the & char as an escape char but it doesn't seemed to work. Anyone has any idea why is this happening and how can I go abt to insert the & char into the table? TIA.

-- 
Choon Leong

Received on Tue Feb 11 1997 - 00:00:00 CST