Oracle SQL Developer (Generating Pie Charts)

Question

Just leaving a note here in case anyone uses Oracle SQL Developer and happens to have a better solution to the problem.

E.g.

SELECT COL1, COUNT(COL2) AS T_COL2 FROM TABLE 1 GROUP BY COL1;

would return:

COL1 T_COL2
A 20
B 30
C 50

I need to generate a pie chart which only groups by one column. The problem is that generating pie charts using Oracle SQL Developer requires us to group things by two columns. A dirty fix would be to do:

<continued in thread post #1>

Answer 1

... A dirty fix would be to do:

SELECT COL1, COL1, COUNT(COL2) AS T_COL2 FROM TABLE 1 GROUP BY COL1, COL1;

which would feed two columns to fulfill the reqs. Setting the chart type to 'Pie - with Bar' would generate a pretty decent single pie chart (with a non-functional bar). However, I believe there are better options to this.

Pls fix. :3