Question on Editor (Not beta version)...

Toad for Oracle
1

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

2

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

3

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

4

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

5

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

6

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

7

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

8

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

9

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

10

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

11

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

12

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

13

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

14

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