A common misconception when writing PL/SQL select …. into … statements is that if it is an aggregation query (a query that is using an aggregation like count, max, min, avg, etc.) then they always return a result – possibly null – so a NO_DATA_FOUND exception will never occur. 640 more words
Tags » GROUP BY
The SQL language is very intuitive. Until it isn’t.
Over the years, a lot of people have criticised the SQL language for a variety of reasons. 2,735 more words
I started out my morning delightfully forgetful yesterday’s research mission.
As I fed my cats, made coffee, drove to work, and began settling into my day, I intermittently listened (and re-listened) to the first third of Episode 29 of… 332 more words