Project Manager - FTP - convert Toad 9.1 to Toad 10.0

Toad for Oracle
41

Or you could join the TOAD Beta program and always be on the bleeding edge of
TOAD technology.

Dan Clamage

Oracle Database Developer

C O N F L U E N C E

412.246.1806 direct

412.802.8632 main

412.802.8647 fax

THE MATERIAL CONTAINED IN THIS MESSAGE IS CONFIDENTIAL AND IS SUBJECT TO
RESTRICTIONS ON ITS DISCLOSURE. The recipient acknowledges that the information
contained herein is the exclusive, proprietary and confidential property of
Confluence Technologies, Inc. and shall be at all times regarded, treated and
protected as such by the recipient. The use and disclosure of this information
is subject to the restrictions contained in the Software License Agreement
between the recipient (or the recipient’s employer or its affiliates) and
Confluence Technologies, Inc.
image001.jpeg

42

Or you could join the TOAD Beta program and always be on the bleeding edge of
TOAD technology.

Dan Clamage

Oracle Database Developer

C O N F L U E N C E

412.246.1806 direct

412.802.8632 main

412.802.8647 fax

THE MATERIAL CONTAINED IN THIS MESSAGE IS CONFIDENTIAL AND IS SUBJECT TO
RESTRICTIONS ON ITS DISCLOSURE. The recipient acknowledges that the information
contained herein is the exclusive, proprietary and confidential property of
Confluence Technologies, Inc. and shall be at all times regarded, treated and
protected as such by the recipient. The use and disclosure of this information
is subject to the restrictions contained in the Software License Agreement
between the recipient (or the recipient’s employer or its affiliates) and
Confluence Technologies, Inc.
image003.jpeg

43

i think you need to use && instead of &

Correct - when in doubt, TOAD will attempt to behave the

same as SQL Plus - and this is how Oracle defines the bahvior

You might want to make sure the first selection is a single & while the rest are
a double &.

Using a && for all of them, SQL Plus will prompt for the variable the first time
around, then use that same variable across multiple runs in the same session.

In order to be able to use a different value between runs in the same session,
your first instance of a variable needs to be & rather than &&. Then
you’ll be prompted for the value between sessions.

I confirmed on Toad 9.7.2.5 that it is set up to always prompt for the first
instance whether you have & or &&. However, it is good practice to ensure what
you want will occur consistently when you run your script in SQL Plus.

Roger S.