oracle视图建主键
时间：2021-07-01 10:21:17
帮助过：2人阅读
as AGENTID, ---
座席编号
(SELECT B.OPERATOR_NAME
FROM CC_AGENT_INFO B
WHERE B.WORK_NO = A.AGENTID) AS AGENTNAME, ----
坐席姓名
NVL(SUM(C.BUSYNUM), 0) AS BUSYNUM, -----
示忙次数
NVL(SUM(C.RESTNUM), 0) AS RESTNUM, ------
休息次数
NVL(SUM(C.RESTTIME), 0) AS RESTTIME, ------
休息时长（分钟）
NVL(D.DEVICENO_NUM, 0) AS DEVICENONUM, -------
接话总量
NVL(D.DEVICENO_SUM, 0) AS DEVICENOSUM-------
接话总时长
FROM CC_V_..... A
LEFT JOIN 。。。。。。
LEFT JOIN 。。。。。。
GROUP BY A.AGENTID, D.DEVICENO_NUM, D.DEVICENO_SUM;
View Code
查看是否已经存在主键
select a.constraint_name, a.column_name
from user_cons_columns a, user_constraints b
where a.constraint_name = b.constraint_name
and b.constraint_type = ‘P‘
and a.table_name = ‘SME_V_A....‘
View Code
oracle视图建主键
标签：
