Custom Browser Folders

[matjazc]

Is it possible to define custom browser folder with contents different from all_objects ?

For example I would like to make my own folder "sessions", "schemas", "redo logs" or "datafiles" and define SQL for its contents.

I am already using browser extender plug-in (which is great btw), but in combination with what I have wished for it could make priceless DBA tool.

 

[Marco Kalter]

No, only the known object types from all_objects can be queried. I have added your suggestion to the list of enhancement requests though.

 

[davemans]

You can fool the browser to some extent by putting something like this in the WHERE clause :-

Owner = 'Dummy'
UNION
SELECT field1, field2, field3, field4
FROM some_table

field1 is interpreted as the user and is not displayed if the same as the connected user else it prefixes field3 which is the object name.
field2 is the object type and determines which icon is used - nothing is displayed if this is not a recognized type.
field4 is the status and should be 'VALID' or 'INVALID'

 

[matjazc]

Good one. Thanks.

 

[Marco Kalter]

Neat trick .

 

[LMW]

Hello,

indexes and constraints don't seem to be on the list of recognized types, nor do some newer object types like OPERATOR, TABLE PARTITION do.

Can they be added to this list.

Regards
LMW

 

[matjazc]

Marco, can you tell me, where do these "settings" get stored in case I would like to share additional lists with my coworkers ?

I know Browser Extender stores its contents in *.be files. What about plsdev's custom folders ?

 

[matjazc]

OK. I've got it.
Sorry, I should have looked thoroughly before.

./Preferences/account_name/user.prefs

 

[Marco Kalter]

They are stored in the user.prefs file under the [BrowserFolders] section. The user.prefs file is located in the Preferences\ subdirectory in the PL/SQL developer directory.

if the PL/SQL Developer directory is read-only for the user, the file is located in the Application Data\PLSQL Developer\Preferences\ subdirectory in your Windows profile.

 

[William Robertson]

While we're on the subhect of customising the browser, I notice that custom subdirectories don't inherit the filter you selected. For example under "Tables" I created subdirectories "External", "Object" and "Partitioned", but although I set the filter to "My objects", there is no way to access this when defining my subdirectories, so they show all users' tables regardless. It's not a big deal, but I think it makes the custom subdirectory feature less useful.

 

[matjazc]

Hello,

indexes and constraints don't seem to be on the list of recognized types, nor do some newer object types like OPERATOR, TABLE PARTITION do.

Can they be added to this list.

Regards
LMW

I miss that functionality too. Desperately

 

[Flieger]

Hmm,
i'm trying to get this to work, but have no luck. Can you please give another example?

I tried:

owner = 'DUMMY'
UNION
SELECT 'WCS',ENAME,'TABLE','VALID'
FROM scott.emp

expecting to have the enames listed in that folder.

Thanks,
Christoph

Originally posted by davemans:
You can fool the browser to some extent by putting something like this in the WHERE clause :-

Owner = 'Dummy'
UNION
SELECT field1, field2, field3, field4
FROM some_table

field1 is interpreted as the user and is not displayed if the same as the connected user else it prefixes field3 which is the object name.
field2 is the object type and determines which icon is used - nothing is displayed if this is not a recognized type.
field4 is the status and should be 'VALID' or 'INVALID'

 

[jking]

I think you have the field2 and field3 reversed.

Joe

 

[jking]

field2 is the object type...

Does anyone know the object type to use to get the icon for for a DB_LINK? I've tried "DB_LINK" and some other variations but it doesn't work. I am forced to use "TABLE" to get the links to appear.

Thanks,
Joe

 

[Marco Kalter]

The object type is "DATABASE LINK". You can always check this by right-clicking on an object, selecting "Add to folder", go to Tools > Browser Folders, select your user-defined folder, and click on the "Objects" tab page.

 

[Flieger]

Thanks!!
That did the trick!

 

[Aviga]

Hi,

I tried:

owner = 'DUMMY'
UNION
SELECT owner, 'INDEX' object_type, index_name object_name, DECODE(status, 'VALID', 'VALID', 'INVALID') status
FROM all_indexes

This doesn't return anything.

Furthermore, adding an order by clause containing "owner" column gives me a syntax error.

Thanks in advance.

 

[Marco Kalter]

This doesn't return anything.

An Index is not a base object type, so it will never be contained in a folder.

Furthermore, adding an order by clause containing "owner" column gives me a syntax error.

The order by clause is a separate property of a filter. You will need to use that, or make it empty and add it to the where clause.

 

[Aviga]

Hi Marco,

"An Index is not a base object type..."

I understand then that you filter objects and display only specific types within the browser.

However, it would be nice to be able to see these kinds of objects (which can be selected by all_objects/dba_objects), as well as others like constraints within the browser.

For example, sometimes, an Oracle error regarding a constraint is raised by an application and users don't know how to identify it (the table name is not displayed).

Unfortunately, not everybody knows how to query the dictionary. :-(

This was the reason for my question.

By the way, can we only display objects whose types are visible at the top level of default folders?

Thanks.

 

[markpace]

Hello there,

I think that Indexes and Constraints should be visible in Folders just like Tables and other objects, and should be possible to work on them (drop, extract DDL, and so on)
Just my opinion, but I think it would greatly improve PL/SQL Developer.

Mark

 

[Marco Kalter]

I have added this to the list of enhancement requests.