how to calculate the percentage in oracle?
select count(case when propkey = 0 then 1 end) countid0, count(propkey) totalidcount, source, to_char(round(count(case when properkey = 0 then 1 end)/count(properkey), 3)*100) || '%' percentageids0 from...... Apply round function.