Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HowTo: F5 Run script for several connections from SQL Developer with CONNECT and @

blamaSep 9 2015 — edited Sep 21 2015

Hi all,

how do I run a script for several connections without opening the connections one by one and F5-running the script?

In TOAD one could do it like:

CONNECT user1/pwd1@12.34.56.78:1521/DB11G

@myscript.sql

CONNECT user2/pwd2@12.34.56.78:1521/DB11G

@myscript.sql

CONNECT user3/pwd3@12.34.56.78:1521/DB11G

@myscript.sql

This question was also asked on SO and IMHO the way I showed is correct, see the SQL Developer User Guide.

Thank you

Blama

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2015
Added on Sep 9 2015
7 comments
1,603 views