In TOAD 9 Query Builder has started automatically including ROWNUM in the generated Select statement. Any idea how I can switch this off? It makes it impossible to create summary queries.
Right-mouse-click on the ‘SELECT’ portion of the tree on the left
hand side, and toggle ‘OFF’ the ROWNUM option.