Skip to content
  • Thu. Nov 30th, 2023

CSenthil

Founder of Globalian Trust

fresa-products
  • Home
  • Experience
  • Education
  • Apex
Oracle

Calculate a Percent of Total in Oracle SQL Query Using RATIO_TO_REPORT and OVER ()

ByCSenthil Murugan

Jul 24, 2012 sql

Thanks to gpmilliken

Here’s a quick way to calculate a percentage of total count of events in a query.

SELECT B.PROGRAM_NAME_ID,
         ROUND (RATIO_TO_REPORT (COUNT (*)) OVER () * 100, 2) || ‘%’
            PERCENTOUTAGE
    FROM XFD_PROGRAMS B
GROUP BY PROGRAM_NAME_ID;

Post navigation

Scheduler Email Notification (11g R2 Onwards)
Disabling ACL in 11g –not recommended–for testing

By CSenthil Murugan

Related Post

Apex Oracle

oracle ords – installing in linux

Oct 1, 2021 CSenthil Murugan
Apex Oracle

Oracle Database 21c Express Edition – Oracle XE

Sep 30, 2021 CSenthil Murugan
Oracle Weblogic

oracle reports 2 bug fixes

Aug 3, 2021 CSenthil Murugan
Who is Globalian?
Human, who is living in this global are Globalian. "All are equal on the global" without any boundary like Country, Language, Religion, Caste, Gender and other divisions. For more informations, globalian.org
Donate For Globalian
Categories
  • Apex
  • Computers and Internet
  • Devotional
  • Document
  • Education
  • Educational
  • Experience
  • Friends
  • Health and wellness
  • Helpdesk
  • Marketing
  • Motivational
  • News and politics
  • Oracle
  • Organizations
  • Political
  • politics
  • Skills
  • SQL Developer
  • technical
  • Uncategorized
  • Weblogic
  • Website
  • Windows
Tags
book review css DBA domain download email free softwares html ireport jasper life materialized view MeetingWithFriend naming convention online open source oracle outlook plug-in Recruitment reference region schedule SOD sql sql developer Study Materials sys_guid table tabular form tamil templates thunderbird tools trigger upgrade useful links war website websites welcome windows2012 work style xls young leaders

You missed

Uncategorized

ords configuration changes in tomcat

Aug 16, 2023 CSenthil Murugan
Uncategorized

how to purchase and activate windows license

Jul 5, 2023 CSenthil Murugan
Uncategorized

wifi problem in ubuntu linux

Mar 28, 2023 CSenthil Murugan
Uncategorized

How to handle multiple whatsapp in the system

Feb 16, 2023 CSenthil Murugan

CSenthil

Founder of Globalian Trust

Copyright © CSenthil Murugan | Powered by Fresa Technologies

  • Home
  • About
  • About
  • Fresa
  • Links
  • Newsletter
  • Oracle Apex Training