Toad World® Forums

Question on Editor (Not beta version)...

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

Why?

I know & in SQL prompt character .

Thanks
Kris hnamurthy Maly avantham

Department of Workforce Investment
Division of T echnology S ervices
S ystems M anagement B ranch
500 Mero St., C apitol P laza T ower, 9 th Floor, Room # 903
Frankfort , Kentucky 40601
Phone: (502) - 564 - 4980
Fax: (502) - 564 - 9504
Email: KrishnamurthyT.Malyavantham@ky.gov

" Have a nice Day! "

ole0.bmp
ole0.bmp

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

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

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

Why?
image002.png

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

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

Why?
image001.png

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).
image001.png

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).
image002.png

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

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

If you look closely at the image, it’s also has &D in its prompt list.

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image002.png

If you look closely at the image, it’s also has &D in its prompt list.

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg

If you look closely at the image, it’s also has &D in its prompt list.

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.png

Yeah, I corrected that. The point is: prompting for vars can be disabled for
comments, but not for strings per the reason below. There may be other cases
where variables with strings are desired. If there’s a strong movement to make
this type of variable an option similar to those in comments, then the Idea Pond
is the place to go.

http://toadfororacle.ideascale.com/
image002.png

Yeah, I corrected that. The point is: prompting for vars can be disabled for
comments, but not for strings per the reason below. There may be other cases
where variables with strings are desired. If there’s a strong movement to make
this type of variable an option similar to those in comments, then the Idea Pond
is the place to go.

http://toadfororacle.ideascale.com/
image001.jpeg

Yeah, I corrected that. The point is: prompting for vars can be disabled for
comments, but not for strings per the reason below. There may be other cases
where variables with strings are desired. If there’s a strong movement to make
this type of variable an option similar to those in comments, then the Idea Pond
is the place to go.

http://toadfororacle.ideascale.com/
image001.png