Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: inserting records
Motley Crue, Vaxxer wrote:
> 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"
I suppose you are using SQLPlus and there you can set the character used to prefix substitution variables with e.g. SET DEFINE '#' or disable scanning for variables with SET DEFINE OFF or SET SCAN OFF. Received on Tue Feb 11 1997 - 00:00:00 CST