<div>
same message for the following strings.<br />
<br />
economics<br />
info<br />
global
</div>


same message for the following strings.

economics
info
global

<div>
In case you missed my post while you were typing:<br />
set define off
</div>


In case you missed my post while you were typing:
set define off

<div>
yes, I use sqlplus. Can I still set echo on?<br />
Thanks.
</div>


yes, I use sqlplus. Can I still set echo on?
Thanks.

<div>
&gt;&gt;Can I still set echo on?<br />
<br />
Yes.<br />
<br />
Here is the online docs about the '&amp;':<br />
<a href="http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm" rel="ugc">http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm</a><br />
<br />

<blockquote>
You can SET DEFINE OFF to prevent scanning for the substitution character.
</blockquote>
</div>


>>Can I still set echo on?

Yes.

Here is the online docs about the '&':
http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm [http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm]



> You can SET DEFINE OFF to prevent scanning for the substitution character.

<div>
or replace the &amp;&nbsp;with chr(38)
</div>


<div>
You can also try setting the below :<br />
<br />
Set define off<br />
set scan off
</div>


You can also try setting the below :

Set define off
set scan off

<div>
I am aware that scan off is obsolete in the latest versions but just want you to try if in case the define off does not help for some reason.
</div>


I am aware that scan off is obsolete in the latest versions but just want you to try if in case the define off does not help for some reason.

<div>
&quot;set define off&quot; has already been posted. &nbsp;Several times...
</div>


"set define off" has already been posted.  Several times...

<div>
<div class="content wysiwyg-content">
Greeting,<br />
<br />
I have update stmts like the following. When I ran it, it popup a message &quot;Enter value for recreation: &quot;&nbsp;<br />
What is it for? Any suggestions?<br />
<br />
Update TBL1<br />
set desc='ATHLETICS &amp;&nbsp;RECREATION'<br />
where id='005'<br />
<br />
Thanks.
</div>
</div>


Greeting,

I have update stmts like the following. When I ran it, it popup a message "Enter value for recreation: " 
What is it for? Any suggestions?

Update TBL1
set desc='ATHLETICS & RECREATION'
where id='005'

Thanks.

Urgent: Update query issue in Oracle 11g

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.