Teradta建立视图语句，

Teradta建立视图语句，

1.

 

CREATE VIEW dept
(DeptNo, DeptName, Loc, MgrNo)
AS
SELECT DeptNo	(Title 'Department Number')
	,DeptName	(Title 'Department Name')
	,Loc	(Title 'Department Location')
	,MgrNo	(Title 'Manager Number')
FROM SampDb.Department;

  

2

REPLACE VIEW RPTMARTVW.TB_RPT_TOT_IP_MSG_DAY (
        DEAL_DATE     
       ,CUST_ID       
       ,USER_ID       
       ,USER_TYPE     
       ,IP_S          
       ,IP_E                
       ,WAY           
       ,VDATE         
 ) AS LOCKING RPTMART2.TB_RPT_TOT_IP_MSG_DAY FOR ACCESS SELECT
       DEAL_DATE           (TITLE '处理日期'),
       CUST_ID             (TITLE '客户ID'),
       USER_ID             (TITLE '用户ID'), 
       USER_TYPE           (TITLE '用户类型'), 
       IP_S                (TITLE '起始IP'),
       IP_E                (TITLE '终止IP'),
       WAY                 (TITLE '使用方式'),
       VDATE               (TITLE '使用日期')
FROM RPTMART2.TB_RPT_TOT_IP_MSG_DAY;
 

3

CREATE VIEW EmpInfo
(WorkerName, WorkerYrs, Department, 
 ManagerName, ManagerYrsExp)
AS
SELECT	Workers.Name, Workers.YrsExp, Workers.DeptNo,
	managers.Name, managers.YrsExp
FROM	employee Workers
	,employee Managers
WHERE	Workers.DeptNo = managers.DeptNo
AND	managers.JobTitle IN ('Manager','Vice Pres')
AND	Workers.YrsExp > managers.YrsExp;