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

Correction: the second variable in your screenshot (&D) is indeed from the comment, but that can be unset in Options>Execute/Compile

From: [email protected] [mailto:[email protected]] On Behalf Of Matt Wilkins
Sent: Monday, December 19, 2011 2:27 PM
To: [email protected]
Subject: RE: [toad] RE: Question on Editor (Not beta version)...


This has nothing to do with the second line being commented. It's prompting for what it thinks is the variable in the first line. SQL*Plus does the same thing.

Besides, variables within quoted strings can be useful (such as when generating INSERT statements).

From: [email protected] [mailto:[email protected]] On Behalf Of Malyavantham, Krishnamurthy T (Education Cabinet)
Sent: Monday, December 19, 2011 1:55 PM
To: [email protected]
Subject: RE: [toad] RE: Question on Editor (Not beta version)...


Dear Bert,
See the scenario below

TOAD Version 9.6.1.1

Run the stmt
select   'Test & Dev' My_Col
      -- , 'T & D' Another_Col

from dual;

Displays

Test & Dev

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

TOAD Version 11.0.0.116

Run the stmt
select   'Test & Dev' My_Col
    --   , 'T & D' Another_Col

from dual;

Displays prompt dialog box

[cid:[email protected]]

Second line is commented still TOAD is asking in prompt. I think TOAD shouldn't read the COMMENTED code for prompt.

Why?


From: [email protected] [mailto:[email protected]] On Behalf Of Bert Scalzo
Sent: Monday, December 19, 2011 12:21 PM
To: [email protected]
Subject: [toad] 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.