This discussion is archived
2 Replies Latest reply: Dec 26, 2012 8:37 AM by Jim Smith RSS

Get Column sum, count in sql developer

G.Y Newbie
Currently Being Moderated
Dear All seniors,
I need help in oracle sql developer that after select statement when we got our result in below rows and coloums,
then how to get its sum, count, etc.
as in pl sql developer we simply right click at a column and then click on the desired function.
is this facility also have in sql developer?
  • 1. Re: Get Column sum, count in sql developer
    Jim Smith Expert
    Currently Being Moderated
    SQL Developer doesn's provide this.

    You can request it as an enhancement in the SQL Developer exchange (link at the top of the forum)
  • 2. Re: Get Column sum, count in sql developer
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    We've kicked around the idea of doing this for awhile. I believe there's already an item in the Exchange if you want to up vote it. The challenge being if it's a result set which hasn't been fully fetched, doing an aggregate would require one - and that could be costly. Of course folks live in the grids so I see the value in this type of feature as well.

    As a workaround, you could of course export your data to CSV or XLS and do the calculations in your favorite spreadsheet software.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points