这篇文章将为大家详细讲解有关Oracle中RATIO_TO_REPORT() OVER()函数的作用是什么，文章内容质量较高，因此小编分享给大家做个参考，希望大家阅读完这篇文章后对相关知识有一定的了解。

20:00:24SYS@orcl>connscott/tiger;Connected.20:00:30SCOTT@orcl>createtabletest20:01:222(20:01:223namevarchar(20),20:01:224kemuvarchar(20),20:01:225scorenumber20:01:226);Tablecreated.Elapsed:00:00:00.0420:01:23SCOTT@orcl>insertintotestvalues('testa','yuwen',10);1rowcreated.Elapsed:00:00:00.0220:01:35SCOTT@orcl>insertintotestvalues('testa','英语',100);1rowcreated.Elapsed:00:00:00.0020:01:35SCOTT@orcl>insertintotestvalues('testb','yuwen',60);1rowcreated.Elapsed:00:00:00.0120:01:36SCOTT@orcl>insertintotestvalues('testb','yuwen',120);1rowcreated.Elapsed:00:00:00.0020:01:36SCOTT@orcl>insertintotestvalues('testc','yuwen',40);1rowcreated.Elapsed:00:00:00.0020:01:37SCOTT@orcl>commit;Commitcomplete.Elapsed:00:00:00.0020:01:42SCOTT@orcl>selectname,20:03:322score,20:03:323ratio_to_report(score)over()asratio1,20:03:324ratio_to_report(score)over(partitionbykemu)asratio220:03:325fromtest;NAMESCORERATIO1RATIO2--------------------------------------------------testa10.03030303.043478261testb60.181818182.260869565testc40.121212121.173913043testb120.363636364.52173913testa100.3030303031Elapsed:00:00:00.0020:03:33SCOTT@orcl>

关于Oracle中RATIO_TO_REPORT() OVER()函数的作用是什么就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。