Re: inserting values into a table

"Taff Evs" <taffevs_at_aol.com> wrote in message news:20040301153155.01855.00000673_at_mb-m22.aol.com...
|
| Can anyone tell me how I insert the '&' value in a string without
producing an
| error message?
|
| I want to insert a string into a table that incorporates the '&' operator
| e.g. 'Fish & Chips'
|
| Cheers
|
| Ben
|
|

assuming SQL*Plus

set scan off

or

set define off

or

set esc \, and use \&

or

use chr(38)

;-{ mcs Received on Mon Mar 01 2004 - 14:40:48 CST