Re: Inserting text including &

I assume you are doing this in sql*plus, where the & represents a variable.. to get around the problem you have to do this:

insert into table
(col1)

values
('this is a test'||'&'||'this is not');

Note that you seperate the & into it's own quotes and cat it to the other
values.

Robert Received on Wed Jul 14 1999 - 17:39:09 CDT