给视图加主键

  
--资格审查的视图

create or replace view view_person_zgsc(USER_SFZ,USER_NUMBER,USER_XM,USER_XB,USER_CSNY,USER_JG,USER_MZ,USER_ZZMM,USER_RZNF,USER_CJGZSJ,USER_SHDW,
      USER_GZDW,USER_DWCJ,USER_GZDD,USER_XLXW,USER_BYYX,USER_BYYXLB,USER_SXZY,USER_ZYJSZG,USER_ZYJNDJ,USER_GWDJ,USER_ZJCH,USER_RZSJ,USER_NN,
	  FLOW_START_TIME,FLOW_STATE,FLOW_CS_TIME,FLOW_CS_STATE,FLOW_CS_USER,FLOW_CS_OPINION,FLOW_CS_SUBTIME,FLOW_CS_SUBUSER,FLOW_CS_BK,
	  FLOW_FH_TIME,FLOW_FH_STATE,FLOW_FH_USER,FLOW_FH_OPINION,FLOW_FH_BK,FLOW_JCJF,FLOW_ZF,shdw,gzdw,CONSTRAINT id_pk PRIMARY KEY (USER_SFZ) RELY DISABLE NOVALIDATE) as 
  select
   p.USER_SFZ,
   p.USER_NUMBER,
   p.USER_XM,
   p.USER_XB,
   p.USER_CSNY,
   p.USER_JG,
   p.USER_MZ,
   p.USER_ZZMM,
   p.USER_RZNF,
   p.USER_CJGZSJ,
   p.USER_SHDW,
   p.USER_GZDW,
   p.USER_DWCJ,
   p.USER_GZDD,
   p.USER_XLXW,
   p.USER_BYYX,
   p.USER_BYYXLB,
   p.USER_SXZY,
   p.USER_ZYJSZG,
   p.USER_ZYJNDJ,
   p.USER_GWDJ,
   p.USER_Z