I find SQL Developer's "Autogenerate Group By" function very useful. But it can be quite annoying as well, especially when I'm editing an existing query. It would be great if I could create my own code up to a point, and then invoke the "autogenerate" function when I'm ready.
I saw this blog post by Jeff Smith: http://www.thatjeffsmith.com/archive/2012/07/auto-generate-group-by-clauses-with-oracle-sql-developer/. It seems to indicate that this is in fact possible, quote: "I disable the automatic bits and just call it on demand with ctrl+spacebar". Ctrl-spacebar doesn't seem to do anything with "auto-group by" for me. Am I missing something?
This is one of the changes coming in SQL Developer 4.0, with the "Semantic Advisor" feature (the early adopter release is out if you want to play with it).
See Jeff Smith's blog post for more info.