multiple instances - connect info

[heike0815hh]

Hello,

when I have multiple instances with different connects, how can I get the connect-info for each window. (Why isn't the connect-info on each window-frame?)

Regards Heike

 

[Marco Kalter]

You can see the connection in the status bar at the bottom of the window. You can also change the connection there.

 

[BRi-17]

Hello,

would it be possible to set the corresponding SQLPROMPT in the Command Window, e.g. "user@database> " instead of "SQL> "?

In SQL*Plus you can set it in the ORACLE_HOME\sqlplus\admin\glogin.sql by adding command:
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> ".

Regards Berit.

 

[gareth_moore]

It would be useful to have the option of automatically showing the connection in the Window List, eg. user@database SQL Window - New.

I know you can rename it but if you're running multiple windows with multiple connections, this would be useful.

 

[Marco Kalter]

would it be possible to set the corresponding SQLPROMPT in the Command Window, e.g. "user@database> " instead of "SQL> "?

You can use the "set prompt [user]@[db]" command. Put this in the login.sql file in the PL/SQL Developer directory to make this the default prompt.

 

[BRi-17]

Thank you for this advice!

When I open a new command window or change the connection by typing in "connect user/pw@db" the current user and database is displayed, but when I change the connection by the new connection list at the status bar and execute a statement, the prompt is NOT changed to the new connection.

Could you please fix it?

Regards Berit.

 

[Marco Kalter]

That is indeed not right. We'll fix it.