Re: Help with "&"

To update a field use
update tablename set fieldname = 'some new value'

the where clause selects which records to apply the update on i.e. where otherfieldname = 'Update me'

& is a special character in SqlPlus that indicates that a variable name follows it and, if no pre-set value for the variable exists, it prompts you for one.

Hope it helps,
John Greco
Oracle DBA
Reply to john.greco_at_dot.state.mn.us

rockhead33_at_aol.com (Rockhead33) wrote:

>We are trying to do a simple update in a field.
>UPDATE tablename set fileldname = "blah"
>where fieldname = "blah blew & etal"
>
>It is returning a prompt to enter in a string for etal.
>Is & a wildcard or something else in Oracle? Do I need a litoral symbol of
>some kind?
>I dont have much more info than that. And I do not know oracle. Sorry.
>Thanks in advance
Received on Wed Dec 10 1997 - 00:00:00 CST