| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to insert an & in a table with an SQL-statement.
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
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
 |
 |