The main window title bar always displays "Username@Database" based on how you logged into Oracle when starting PL/SQL Developer (or when you use Session -> Log on...). Is there a way to change that text to something else, and if so, can it be done dynamically (sort of like SET PROMPT can change the SQL> prompt in the Command Window)?
What I would like to do is have the title bar reflect the value of SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'). i.e, the value of the schema name when doing 'ALTER SESSION SET CURRENT_SCHEMA = blah'.
Note, we have 'Allow Multiple Connections' turned off, so we don't need to manage the value for different connections.
Thanks, Maury
What I would like to do is have the title bar reflect the value of SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA'). i.e, the value of the schema name when doing 'ALTER SESSION SET CURRENT_SCHEMA = blah'.
Note, we have 'Allow Multiple Connections' turned off, so we don't need to manage the value for different connections.
Thanks, Maury
