Pro Oracle SQL Chapter 8
caohong286
这个作者很懒,什么都没留下…
展开
-
《Pro Oracle SQL》Chapter 8 -- 8.1-8.2 Anatomy of Analytic Functions -8.3
Riyaj Shamsudeen (page 243) Online Analytic Processing (OLAP) queries perform multi-dimensional aggregation and are useful in business decision-making processes in areas such as sales, marke...2012-02-11 11:16:21 · 145 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 8 -- 8.4Aggregation Functions
Aggregation Functions 聚合函数 (page 246) Aggregation functions can operate in analytic mode or conventional non-analytic mode. Aggregation functions in non-analytic mode reduce the res...2012-02-17 01:47:48 · 158 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 8 -- 8.5 Lead and Lag
Lead and Lag (page 249) Lag and lead functions provide inter-row referencing ability. Lag provides the ability to access prior row in the result set. The lead function allows acce...2012-02-19 16:07:42 · 130 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 8--8.6 First_ value & Last_value
First_value & Last_value (page 252) First_value and last_value functions are useful in calculating the maximum and minimum values in an orered result set. The first_...2012-02-21 23:52:55 · 86 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 8 -- 8.7 Other Analytic Functions 之一
Other Analytic Functions (page254) Oracle Database implements a great many other analytic functions. Some of those more commonly used are described in the following subsections. The fu...2012-02-26 14:35:47 · 204 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 8 -- 8.7 Other Analytic Functions 之二
Ratio_to_report (page 259) The analytic function ratio_to_report calculates the ratio of a value to the sum of values in the datapartition. If the partitioning clause is not s...2012-02-26 22:14:26 · 108 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter 8 -- 8.7 Other Analytic Functions 之三
NTILE (page 263) The NTILE function divides an ordered set of rows in a data partition, groups them in to buckets, and assigns a unique group number to each group. This functi...2012-02-29 22:09:07 · 103 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter8--8.8 Performance Tuning
Performance Tuning 性能调优 (page 266) Analytic functions are very useful in tuning complex SQL statements. Inter-row referencing, aggregation at multiple levels, and nth-row access are a...2012-03-02 23:11:09 · 83 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter8--8.9 Advanced topics
Advanced topics 高级主题 (page 268) A few advanced topics about the analytic functions are worthy of discussion. I will discuss topics such as dynamic analytic statements, nesting of anal...2012-03-05 21:41:25 · 104 阅读 · 0 评论