Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle ampersand help
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