3 comments:

maybe that can explain why some of the paste I've done started pasting things I did not copy, or at least do not remember to copy. I find the latest version to be extremely weird in that. I'm pasting a table name and end up with "group by" few rows below...

Niva, thank you for your comment. The "group by" is automatically added (since SQL Developer 2.1) whenever you use an aggregate in the query. There is a setting that influences this behaviour.Tools --> Preferences --> Code Editor --> Completion Insight. There is a checkbox labeled "Autogenerate GROUP BY clause". When you uncheck this the automatic Group By won't happen anymore.

the only problem with this technique, is the fact of cause a little problem call it "term anteposicition", this happen when a term used to define something copy the pattern of something totally different.

About Me

Self-employed under the name allAPEX, mainly in The Netherlands. Presented at National and International Conferences. Oracle ACE Director for Database Development. Trainer for SQL and PL/SQL. Married, two children, likes to Barbecue.