RATIO_TO_REPORT « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. RATIO_TO_REPORT
1.RATIO_TO_REPORT Demo
2.RATIO_TO_REPORT can easily be partioned as well
3.Portion amounts add to 1.000 in each region
4.Notice that the PORTION column adds up to 100%
5.RATIO_TO_REPORT, break on and compute
6.RATIO_TO_REPORT(): compute the ratio of a value to the sum of a set of values