What is the purpose of Ratio_To_Report Function of Oracle?

Answer:

It is an analytical function that computes the ratio of a value over the total set of values.RATIO_TO_REPORT of 5 over (1,2,3,4,5,6,7,8,9,10) is (5/55) i.e. 0.09090909090909090909090909090909

e.g

SQL> Select EmpName,Salary,Ratio_to_Report(SALARY) Over() As RatioReportExample

  2  From tblEmployee

  3  Where DeptId = 1;



EMPNAME                                                SALARY RATIOREPORTEXAMPLE

-------------------------------------------------- ---------- ------------------

Arina Biswas                                           6000         .146305779

Jitesh Mallik                                           16000         .390148744

Deepak Singh                                             6890         .168007803

Shashi Bhushan                                           5120         .124847598

Atithi Salonki                                           7000         .170690076