您希望在分组集上使用GROUP BY CUBE和条件聚集和过滤器：

SELECT CASE GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END)
       WHEN 0
       THEN TO_CHAR(status)
       WHEN 2
       THEN 'SUB-TOTAL'
       ELSE 'TOTAL'
       END AS status,
       COUNT(CASE user_type WHEN 1 THEN 1 END) AS "1",
       COUNT(CASE user_type WHEN 2 THEN 1 END) AS "2",
       COUNT(CASE user_type WHEN 3 THEN 1 END) AS "3",
       COUNT(CASE user_type WHEN 5 THEN 1 END) AS "5",
       COUNT(*) AS total
FROM   table_name
GROUP BY CUBE(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END)
HAVING GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END) IN (0, 3)
OR     (   GROUPING_ID(status, CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END) = 2
       AND CASE WHEN status IN (2, 4, 5) THEN 1 ELSE 0 END = 1 )

对于示例数据（表示多个联接表的输出）：

CREATE TABLE table_name (status, user_type) AS
  SELECT 2, 1 FROM DUAL CONNECT BY LEVEL <=  3 UNION ALL
  SELECT 4, 1 FROM DUAL CONNECT BY LEVEL <= 13 UNION ALL
  SELECT 5, 1 FROM DUAL CONNECT BY LEVEL <=  1 UNION ALL
  SELECT 3, 1 FROM DUAL CONNECT BY LEVEL <=  5 UNION ALL
  SELECT 3, 5 FROM DUAL CONNECT BY LEVEL <=  1 UNION ALL
  SELECT 0, 1 FROM DUAL CONNECT BY LEVEL <=  4 UNION ALL
  SELECT 0, 5 FROM DUAL CONNECT BY LEVEL <=  8;

输出：
| 状态|一个|2个|三个|五个|总计|
| - -|- -|- -|- -|- -|- -|
| 第0页|四个|第0页|第0页|八个|十二|
| 三个|五个|第0页|第0页|一个|六个|
| 2个|三个|第0页|第0页|第0页|三个|
| 四个|十三|第0页|第0页|第0页|十三|
| 五个|一个|第0页|第0页|第0页|一个|
| 小计|十七岁|第0页|第0页|第0页|十七岁|
| 总计|二十六人|第0页|第0页|九个|三十五|
您可以更改字符串文字以匹配所需输出的行标题。
fiddle

这样做的一个选项是使用MODEL子句，如下所示：

Select 
    *
From
    (
        Select Cast(p.STATUS as VARCHAR2(30)) "STATUS",  p."1", p."2", p."3", p."5"
        From pivot_table p Union All
        Select 'Sum of Statuses 2, 4, 5', Null, Null, Null, Null From Dual Union All
        Select 'Sum of All Statuses', Null, Null, Null, Null From Dual
    ) 
MODEL
    Dimension By      (STATUS)
    Measures          ("1", "2", "3", "5", 0 "TOTAL")
    Rules     
          (
              "1"['Sum of All Statuses'] = Sum("1")[ANY],     -- Grand Total of Column 1 = Sum(1) for ANY Status (Dimension)
              "2"['Sum of All Statuses'] = Sum("2")[ANY],
              "3"['Sum of All Statuses'] = Sum("3")[ANY],
              "5"['Sum of All Statuses'] = Sum("5")[ANY],
              --
              "1"['Sum of Statuses 2, 4, 5'] = Sum("1")[STATUS IN('2', '4', '5')],    -- SubTotal of Column 1 = Sum(1) for Status IN 2, 4, 5
              "2"['Sum of Statuses 2, 4, 5'] = Sum("2")[STATUS IN('2', '4', '5')],
              "3"['Sum of Statuses 2, 4, 5'] = Sum("3")[STATUS IN('2', '4', '5')],
              "5"['Sum of Statuses 2, 4, 5'] = Sum("5")[STATUS IN('2', '4', '5')],
              --
              TOTAL[ANY] = "1"[CV()] + "2"[CV()] + "3"[CV()] + "5"[CV()]      -- for each row do the addition of columns with the same Current Value 'CV()' of Status
          )

根据您问题中的数据：

WITH
    pivot_table AS
        (   
       Select 2 "STATUS", 3 "1", 0 "2", 0 "3", 0 "5" From Dual Union All
       Select 4 "STATUS", 13 "1", 0 "2", 0 "3", 0 "5" From Dual Union All
       Select 5 "STATUS", 1 "1", 0 "2", 0 "3", 0 "5" From Dual Union All
       Select 3 "STATUS", 5 "1", 0 "2", 0 "3", 1 "5" From Dual Union All
       Select 0 "STATUS", 4 "1", 0 "2", 0 "3", 8 "5" From Dual 
        )

结果应该是：
| 状态|一个|2个|三个|五个|总计|
| - -|- -|- -|- -|- -|- -|
| 2个|三个|第0页|第0页|第0页|三个|
| 四个|十三|第0页|第0页|第0页|十三|
| 五个|一个|第0页|第0页|第0页|一个|
| 三个|五个|第0页|第0页|一个|六个|
| 第0页|四个|第0页|第0页|八个|十二|
| 状态2、4、5的总和|十七岁|第0页|第0页|第0页|十七岁|
| 所有状态的总和|二十六人|第0页|第0页|九个|三十五|
此致