Program window, how to remove prefixed schema name in window title when viewing database source?

Claus Pedersen

Member³
I have the setting: Allow multiple connections=No.
When I view some database source (for instance a package), I have the program window title: "Program Window - View source of package spec & body MY_SCHEMA.MY_PACKAGE"

How do I get rid of MY_SCHEMA? It is redundant (and takes up my real estate in the Window list) since the schema name is already in the PLD title.

This was reported earlier in the version 10 beta forum, but I got no solution.

Also, to preserve screen real estate, the words "View ..." could be omitted in titles like "Program Window - View source of package spec & body SCOTT.MY_PACKAGE@MY_DB" which could easily be shortened into "Program - Package my_package", "View table SCOTT.EMP@MY_DB" could be "Table emp", etc.
When editing, the title could be "Program - Edit package my_package", "Edit package spec my_package", "Edit sequence my_sequence", etc.
 
This issue has apparently not been addressed/solved in version 11 beta 7.

I always use "Allow multiple connections"=No, so my fixed connection is already shown in PLD main window:
SCOTT@MY_DB - PL/SQL Developer
so there is no need to replicate it on each open program window.

Even when using short text in the window list, the full text becomes
P - SCOTT.MY_PACKAGE@MY_DB
where
P - MY_PACKAGE
would save a lot of my precious screen real estate (possibility to make my window list much slimmer sidewise).

If the current schema is changed, it would be OK for me to show
P - SCOTT.MY_PACKAGE@MY_DB
to indicate the origin of the package, but when reverting back to SCOTT, the window title should again be
P - MY_PACKAGE
 
I want to endorse, for these generated window headers (especially for SQL Windows) are so hard to read, that something has to be done.
At times I even think that it would be better to just assign names as autoincremented numbers: "1","2","3",...

Meanwhile, I would like to suggest changing:
instead of:
[size=8pt]Test Window - Script for function ECONTRAMAN.REFERENCES_PKG.LIST_RESP_PERSONS@TOR.FOGC.LOCAL [/size]
to:
[size=8pt]T: unit econtraman.REFERENCES_PKG.LIST_RESP_PERSONS[/size] ##

where ## - my color indicator for TOR.FOGC.LOCAL

And the text should be SHORT by default, I suppose.
 
Update: we are beginning to have users identified by the operating system. We log on with a user like [SCOTT] and do not need to enter password.

But logging on this way, makes all SCOTT's objects prefixed with username SCOTT in the object browser. Please fix/improve PLD so we can get rid of these prefixed user names.
 
Back
Top