Re: How to insert an & in a table with an SQL-statement.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 13 Oct 1998 18:55:58 GMT
Message-ID: <362aa216.110125772@192.86.155.100>

A copy of this was sent to "Marten Tacoma" <mtacoma_at_doge.nl> (if that email address didn't require changing) On Tue, 13 Oct 1998 20:48:01 +0100, you wrote:

>Hello..
>
>Could anyone tell me how to insert a & in a field without it promts me for
>a variable.
>I need to send an escape-sequence to a printer to change its settings.
>We are working with forms 3.x (or omething like that), and this version does
>not accept escape sequensys. So I put al nonsenstext in a field en then run
>an sql like this:
>
>upadate tableX
>set field=' xx&yyy'
>where field='nonsenstext'
>/
>

in sqlplus, to turn off this feature, simply:

SQL> set define off

or

SQL> set scan off

that'll disable the macro processing...

>And the & makes the sql ask me for a variable. But what I want is tho put an
>*hard* & in the field.
>
>Anny help ?
>
>Marten Tacoma.
>
>mtacoma_at_doge.nl
>
>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Oct 13 1998 - 13:55:58 CDT