oracle怎么显示百分比-Oracle

SELECT ROUND(SUM(value) / SUM(total) * 100, 2) || '%'
FROM table_name;

SELECT TO_CHAR(SUM(value) / SUM(total) * 100, '99.99%')
FROM table_name;

SELECT FORMAT(SUM(value) / SUM(total) * 100, '0.00%')
FROM table_name;

CREATE FUNCTION get_percent(value NUMBER, total NUMBER) RETURN VARCHAR2 IS
  percent VARCHAR2(10);
BEGIN
  percent := TO_CHAR(value / total * 100, '99.99%');
  RETURN percent;
END;

SELECT get_percent(SUM(value), SUM(total))
FROM table_name;