view.sql

来自「一整套的源代码」· SQL 代码 · 共 11 行

create or replace view v_notinhospitalsick as
select sick.* from sick, inpatient
where sick.sickid = inpatient.sickid (+) and
      inpatient.inpatientid is null and
      to_char(sick.created, 'yyyy-mm-dd') = to_char(sysdate, 'yyyy-mm-dd');

create or replace view v_notinhospitalsicktoll as
select sick.*, reckoning.reckoningid from sick, inpatient, reckoning
where sick.sickid = inpatient.sickid (+) and  reckoning.sickid = sick.sickid  and
      inpatient.inpatientid is null;