Text problem

[Telsa]

I don't know Oracle but am working on a SQL file created that has INSERT INTO statements. These files build webforms.

My predecessor had added a line where the text field needs to have an & in it. The & is part of a link. How do I keep Oracle from flipping out with the & in it? I think it's on a UNIX system. Mary

Violence begets Violence
Let's Give Peace a Chance!!

 

[Wonboodoo]

I assume you are running it in SQL*Plus. Add the following at the start of your script:
set define off

 

[Telsa]

Great! That worked perfectly!

Thanks! Mary

Violence begets Violence
Let's Give Peace a Chance!!

 

[sem]

You may also redefine this character by changing OFF to something else. Regards, Dima