A way to have more than one db connection ?

[Alp]

Hi,

Is it a way to have more than one Oracle session on the same plsqldev instance ?
My goal is to run a sql on a development database connection and after to a production database conncection. And then going back on the same plsqldev instance to my dev. connection !

Txs,

 

[Marco Kalter]

If you want to have multiple connections for different users simultaneously, you will need to start multiple PL/SQL Developer instances.

 

[Alp]

Ok.
But then is it possible to move, or refer to, easely ( not with a copy/paste) the content of the current sql windows on the new plsqldev instance ?
The goal is to deploy (or execute) a sql to multiple databases
Txs,

 

[Marco Kalter]

The fastest way to do this is to switch from one connection to the other by using the logon history.