oracle視圖建主鍵

標籤：

 sys_guid()  -  唯一索引

在Oracle中可以用SYS_GUID()來產生一個guid,相當於msSql中的newid()。

一個項目要求視圖建主鍵，下面是一個例子：

轉：http://blog.csdn.net/myfmyfmyfmyf/article/details/37694731

不好懂，先記著；

CREATE or replace VIEW SME_V_A....  (AGENTID,AGENTNAME,BUSYNUM,RESTNUM,RESTTIME,DEVICENONUM,DEVICENOSUM       ,CONSTRAINT AGENTSTATIC_PK PRIMARY KEY (AGENTID) RELY DISABLE NOVALIDATE) AS SELECT A.AGENTID 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視圖建主鍵