Re: another & question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 8 Dec 2000 20:46:12 -0500
Message-Id: <10705.124142@fatcity.com>

The ampersand thing is only an issue in SQL*Plus. It's the SQL*Plus client (the executable on your machine) that interprets the ampersand (&) as a substitution character. The Oracle database itself does not give the ampersand any special treatment. Thus, you do not need to worry about SQL statements issued by your applications.

Best regards,

Jonathan
mailto:jonathan_at_gennick.com
http://gennick.com

Friday, December 08, 2000, 4:40:33 PM, Dan Johnson wrote:

DJ> what if the data contains an ampersand '&'
DJ> in sqlplus
DJ> select * from weekend
DJ> where timeoff = 'Saturday & Sunday'
DJ> you get
DJ> Enter value for Sunday

DJ> in sqlplus i can set define to another character but how to handle this in DJ> an application? should the application alter its session as well?

DJ> thanks and tgif Received on Fri Dec 08 2000 - 19:46:12 CST