create or replace view v_query(pk_casesid,name1,diseasename,diseasetype,opetime,followuptime,
CONSTRAINT id_pk PRIMARY KEY (pk_casesid) RELY DISABLE NOVALIDATE) as
select his_basicinfo.pk_casesid,his_basicinfo.name,a.sys_name diseasename,b.sys_name diseasetype,his_operation.opetime,his_followup.followuptime
from his_basicinfo,his_diseaseinfo,sys_property a,his_operation,his_followup,sys_property b
where his_basicinfo.pk_casesid not like '4%' and his_basicinfo.pk_casesid= his_diseaseinfo.fk_casesid(+)
and his_basicinfo.pk_casesid=his_operation.fk_casesid(+) and
his_basicinfo.pk_casesid=his_followup.fk_casesid(+)
and his_diseaseinfo.fdiseasename=a.sys_code(+) and a.sys_type(+)='疾病名称'
and his_diseaseinfo.symptom=b.sys_code(+) and b.sys_type(+)='病理特征'
union
select
his_basicinfo.pk_casesid,his_basicinfo.name,a.sys_name diseasename,b.sys_name diseasetype,his_ss.mydate,his_followup.followuptime
from his_basicinfo,his_diseaseinfo,sys_property a,his_ss,his_followup,sys_property b
where his_basicinfo.pk_casesid like '4%' and his_basicinfo.pk_casesid = his_diseaseinfo.fk_casesid(+)
and his_basicinfo.pk_casesid=his_ss.fk_casesid(+) and
his_basicinfo.pk_casesid=his_followup.fk_casesid(+)
and his_diseaseinfo.fdiseasename=a.sys_code(+) and a.sys_type(+)='疾病名称'
and his_diseaseinfo.symptom=b.sys_code(+) and b.sys_type(+)='病理特征';
视图创建主键
最新推荐文章于 2022-05-22 12:51:54 发布