?? view.sql
字號:
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;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -