Re: inserting & into a table

On Tue, 29 Jul 2003 16:26:45 GMT, Karsten Farrell <kfarrell_at_belgariad.com> wrote:

>You can also temporarily change the character that prompts for input from
>an ampersand to another unused character. For example:
>
>set define #
>insert...values('Mani&Anuj');
>set define &
>
>The advantage to this method is that you don't have to go thru your sql
>script and "escape" every ampersand.

 Or if you know you're not using SQL*Plus substitution variables, simply disable them - set scan off.

-- 
Andy Hassall (andy_at_andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)