Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle ampersand help

Re: oracle ampersand help

From: <Christopher.Jones_at_oracle.comX>
Date: 31 Jul 2002 11:13:19 +1000
Message-ID: <ubs8on1hs.fsf@oracle.comX>


rene.nyffenegger_at_gmx.ch (Rene Nyffenegger) writes:

> > how do i insert an ampersand into an orable table? this is urgent.
> > please reply to my email addy.
>
> set scan off

Use the equivalent SET DEFINE OFF.

SET SCAN has been documented as obsolete since SQL*Plus 3.2 (which came with 7.2 of the database). I think it's about time SCAN was permanently removed from SQL*Plus to avoid confusion.

Chris

---

Today's SQL*Plus hint: From SQL*Plus 9.0 onwards explicitly use SET
SQLPLUSCOMPATIBILITY to maximize your script compatibility with future
versions of the SQL*Plus syntax (Note SQLPLUSCOMPATIBILITY does not
affect SQL commands executed in the server, just the client side
control and formatting options.)

-- 
Christopher Jones, Oracle Corporation, Australia.
Received on Tue Jul 30 2002 - 20:13:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US