Enhancement Requests: Default Object Selection, Export Results

[Steve Godrich]

I use PL/SQL Developer as a tool to assist my C# Web development. I generally use schema objects as opposed to Sys objects. When I log in via PL/SQL Developer, I have to change the 'All Objects' setting to 'My Objects' each time. Can we have a setting that allows us to choose whether we always want 'All Objects' as default or 'My Objects' as default? Better still, have an automatic check that sets 'My objects' of you are not logged in as a SYSDBA?

Also, I recently tried exporting the results of a query and found that because I hadn't clicked the 'Fetch Last Page' button, it only exported the small sample it generally supplies. Can we have a message box asking if we are sure we only want the first 23 results only?

They would be great! Thanks!

Steve

 

[CTzen]

Steve,

click on Filters (fifth icon from the left), select "My objects", check [x] "Default", then "Ok".

 

[Steve Godrich]

You are a star!!! I was starting to lose my marbles with that!

IOU 1 beer

 

[ScottMattes]

For extra credit, you can use Tools / Browser Filters to make an entry for often used schemas, OR parts of schemas!

Try entering one for Scott: Description: Scott, User: null (this, if entered, would only show this entry when logged on as the user you put here), Where Clause: owner = 'SCOTT'.

Use the Up/Down arrows to position Scott in the list and maybe check the Default box to make this the one that is used right off the bat.

I have a few set up for just the stuff I'm doing on a subset of the system (owner = 'schema name' and object_name like 'xyz%'), very handy