RE: Question on Editor (Not beta version)...

Toad 11 behavior is correct - you have an ampersand that is not escaped - so interpreted as variable - use sql plus set command to correct

From: [email protected] [mailto:[email protected]] On Behalf Of Malyavantham, Krishnamurthy T (Education Cabinet)
Sent: Monday, December 19, 2011 10:52 AM
To: [email protected]
Subject: [toad] Question on Editor (Not beta version)...
Importance: High



TOAD Version 9.6.1.1

Run the stmt

select 'Test & Dev' My_Col from dual;

Displays

Test & Dev

----======================

TOAD Version 11.0.0.116

Run the stmt

select 'Test & Dev' My_Col from dual;

Displays prompt dialog box

[Picture (Device Independent Bitmap)]

Why?

I know & in SQL prompt character.

Thanks
Krishnamurthy Malyavantham

Department of Workforce Investment
Division of Technology Services
Systems Management Branch
500 Mero St., Capitol Plaza Tower, 9th Floor, Room # 903
Frankfort, Kentucky 40601
Phone: (502) - 564 - 4980
Fax: (502) - 564 - 9504
Email: [email protected]<mailto:[email protected]>

"Have a nice Day!"
---------------------------------------------------------------------------
The information contained in this e-mail message may be privileged, confidential, and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying is strictly prohibited. If you think that you have received this e-mail message in error, please inform the sender; and delete this message permanently from your computer files.