Oracle SQL Developer automatically generates GROUP BY clause when it senses there's any aggregation functions in select clause. This might be helpful when writing a new SQL, but when it comes to debugging a huge complex PL/SQL, it is really annoying.
Fortunately there's an option to disable it, Tools > Preferences > Code Editor > Completion Insight > Autogenerate GROUP BY clause.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment