Jonathan Gennick

Author

Article #3 in my ongoing series covering SQL statistic functions in Oracle Database is now up. The topic is the median: MEDIAN: For When You Don’t Really Mean It Median is useful in typifying a data set when the data might be skewed, or in the presence of extreme outliers. For example, the U.S. Census Bureau reports median household income… Continue Reading →

Application Development, Database Administration, Database Development, Oracle Database, PL/SQL, Uncategorized

I’ve just put up the second in an ongoing series (I hope!) of articles on Oracle SQL’s built-in statistical functions. The topic is standard deviation. I introduce the concept and show one use of it in detecting wide variations that otherwise go unseen in summarized data. Here’s a link to the article: #2. STDDEV: Standing Sentinel on Your Data It… Continue Reading →

Application Development, Database Development

Extract, Transform, and Load (ETL) scenarios sometimes are perceived as mundane and, dare I say it, even boring. Yet I find them fascinating opportunities to apply out-of-the box thinking. Data rarely presents in just the format expected by SQL*Loader or external table syntax. On a good day one builds a straightforward external table and job done. Or is that on… Continue Reading →

11g, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database