2 Replies Latest reply: Aug 8, 2013 2:54 AM by wdriessen RSS

    Autogenerate Group By, only on demand?

    wdriessen

      Hi,

       

      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?

       

      TIA!