I use a named SQL plugin quite a lot, as well as the "Standard Query" functionality built into the program. They are both slightly different and slightly hard to get to. I would like to suggest the following enhancements to the "Standard Query".
1) Menu item that has a drop down showing all of the queries that have been defined, perhaps grouped by owner. This would show the owner/table/query names. Obviously, in some connections the query might not work, but you could at least open a SQL window and copy the code in. Maybe it could remember the most recently used queries and sort them to the top.
2) An option to save a query without attaching it to a table, maybe a generic owner and table name of some kind. These would show on the menu item as a separate "owner" called something like "Named" or "Saved".
3) Some facility to make some of these queries into buttons on the toolbars, maybe with some user created icons. These would be single button clicks to open and run a query that you use a lot.
We deploy PL/SQL Developer to some users that mostly run a few canned queries, but want the capabilities of the full app at times (so Query Reporter is not a good option). I have found the overall quality of the plugins to be lacking and think that with a bit of work, you could make a really nice interface to what you already have.
Dennis
1) Menu item that has a drop down showing all of the queries that have been defined, perhaps grouped by owner. This would show the owner/table/query names. Obviously, in some connections the query might not work, but you could at least open a SQL window and copy the code in. Maybe it could remember the most recently used queries and sort them to the top.
2) An option to save a query without attaching it to a table, maybe a generic owner and table name of some kind. These would show on the menu item as a separate "owner" called something like "Named" or "Saved".
3) Some facility to make some of these queries into buttons on the toolbars, maybe with some user created icons. These would be single button clicks to open and run a query that you use a lot.
We deploy PL/SQL Developer to some users that mostly run a few canned queries, but want the capabilities of the full app at times (so Query Reporter is not a good option). I have found the overall quality of the plugins to be lacking and think that with a bit of work, you could make a really nice interface to what you already have.
Dennis
