sql - 视图 oracle SQL 的相关性

Question

如何计算 Oracle SQL 中视图的相关性。

CORR_S我将函数用于表没有问题，但在视图上使用时会出错。

这是创建的视图。

CREATE VIEW staffavg
AS
SELECT C.staffid AS "staffid", (SELECT S.age
                 FROM staff S
                 WHERE S.staffid = C.staffid) AS "age", ROUND(AVG(C.courseevaluation),2 ) AS "courseavg"
FROM course C
GROUP BY C.staffid
ORDER BY C.staffid

这是我用来获取相关性的函数

SELECT 
CORR_S(courseavg, age) AS "coefficient",
CORR_S(courseavg, age, 'TWO_SIDED_SIG') AS "two sided sig"
FROM staffavg

这是错误

ORA-00904：“AGE”：无效标识符
00904。00000 -“%s：无效标识符”
*原因：
*操作：
第 23 行错误，第 19 列

标签： sqloracle