Re: inserting the value "&"

Moritz Klein wrote:
> Hello NG,
> a problem again but other project.
> I need to insert a & into a field and got stuck with how to escape
> this character properly.
> As to say i am standing on a hose. ;-) (wonder if has same meaning
> like in Germany).
>
> Greetz
> Moritz

This is the query:
INSERT INTO dirs (dirName,ip) values ('/BALD RUNTER/Simon & Garfunkel - The Definitive (1994)/','134.93.40.167');

This is what Oracle prints out:
Enter value for garfunkel: old 1: INSERT INTO dirs (dirName,ip) values ('/BALD RUNTER/Simon & Garfunkel - The Definitive (1994)/','134.93.40.167') new 1: INSERT INTO dirs (dirName,ip) values ('/BALD RUNTER/Simon OEM_sqlplus_input_finished - The Definitive (1994)/','134.93.40.167')

1 row created. Received on Sun Dec 29 2002 - 18:40:03 CST