Re: How to insert data containing a &

I assume this is in SQL*Plus. I can think of two ways.

1. Set escape ! insert into some_table values ('dfjghdg!&fhjhf'); This defines an escape character to tell SQL*Plus to ignore special characters.
2. Define off (or Define <char>) insert into some_table values ('gfhjsg&hfagfgsf'); This stops & being defined as the substitution variable prefix.

Check your SQL*Plus manual for more info. Received on Fri Feb 11 2000 - 08:38:04 CST