一、创建或替换视图
create or replace view PR_IF_SCX as
select (B.YEARPLANTDATE||B.MMPLANTDATE||B.DAYPLANTDATE) AS PLANDATE, B.SHPLANDATE,B.PRSNTSTATLINE, B.HOLDTP,A.PRODSUFFIX,count(*) as CARCOUNT
from PR_T_Vhtb1010 A RIGHT JOIN PR_T_VHTB1040 B
ON A.IDNO=B.IDNO and A.PLANTCODE=B.PLANTCODE and A.PSC=B.PSC
where substr(A.SPEC ,58,1) =' '
GROUP BY (B.YEARPLANTDATE||B.MMPLANTDATE||B.DAYPLANTDATE) , B.SHPLANDATE,B.PRSNTSTATLINE,A.PRODSUFFIX, B.HOLDTP
with read only
二、给用户赋权
grant select on PR_IF_SCX to SCXUSER;
三、创建同义词
create or replace synonym PR_IF_SCX for OUSLC05OPRUSER.PR_IF_SCX;
注:如果替换了视图,必须重新给用户赋权,而且要重新创建覆盖同义词