Enhancement Suggestions

[RobertK]

Will PL/SQL Developer ever (in near future) have the following functionalities ?

1) Multiple tabs of results for SQL Window
2) Basic summary functions on columns
(this is Toad for SQL Server)

Another example of math summary function:
(this is AQT)

The summary would be especially a joy to have so one can stop dumping to Excel all the times....

 

[Roeland]

I support this request.

Notice that the 2 examples you propose use the same grid-component, cxGrid from Developers Express. This grid from Developers Express can even do a lot more then you mentioned. It supports grouping (look at your examples) on multiple columns, summary in grouping, Order By Group Summary Values, order by on multiple columns, export to a whole range of formats, filtering, column-bands, etc, etc...

I have asked this User Interface update more then a year ago. I think that the grid they use now is obsolete and should be replaced by something better.

Why they still haven't updated their ancient grid is beyond my imagination.

Roeland

PL/SQL Dev 9.0.0.1597

 

[RobertK]

Just to add that PLD is a joy for PL/SQL development but rather limiting for "intensive" data analysis.

I'm just guessing here - I think the multi-ResultTab-per-SQL-Window would be easier to implement - this alone will be of tremendous value to cut down the clutters.

 

[Marco Kalter]

Maybe I am missing something, but multiple result sets and aggregate functions like Sum/Min/Max/Avg/Count have been available since version 7.0.

 

[William Robertson]

Why are you asking for something that already exists? What version of PL/SQL Developer do you have?

 

[RobertK]

thanks Marco,
first I must admit I was ignorant of the "Column Totals" feature. My bad.

The multi-result-tabs feature I have in mind is such that a new, separate,distinct tab with the result grid is create for any single query. AFAIK PLD currently doesn't work like that.
- select 2 SQLs, run, get 2 tabs, then select SQL,run, all current tabs get destroyed.

Maybe check out Toad for SQL (freeware).

 

[matjazc]

AFAIK PLD currently doesn't work like that.

mine works exactly like that (v8). I just highlight a couple of SQL statements in SQL window and execute them. Results are displayed in multiple tabs below.

you can even name tabs in v9 beta.

 

[RobertK]

Poster: matjazc
I just highlight a couple of SQL statements in SQL window and execute them. Results are displayed in multiple tabs

Uh ADHD much ?
I know that.

Poster: matjazc
mine works exactly like that (v8)

Read my FULL pos, or this:

> RobertK: select 2 SQLs, run, get 2 tabs, then select SQL,run, all current tabs get destroyed.