--具体内容自己添加 create or replace procedure test iscnt1 number default 0; cnt2 number default 0; cnt3 number default 0; cnt4 number default 0; cnt5 number default 0;begin with tab as (select 20110920 dt from dual ) select max(dt) into cnt1 from tab; --select max(dt) into cnt1 from tab2; --select max(dt) into cnt1 from tab3; --select max(dt) into cnt1 from tab4; --select max(dt) into cnt1 from tab5;if cnt1 > cnt2 then DBMS_OUTPUT.PUT_LINE('cnt1 is the biggest'); end if;end; /
--具体内容自己添加
create or replace procedure test
iscnt1 number default 0;
cnt2 number default 0;
cnt3 number default 0;
cnt4 number default 0;
cnt5 number default 0;begin
with tab as (select 20110920 dt from dual )
select max(dt) into cnt1 from tab;
--select max(dt) into cnt1 from tab2;
--select max(dt) into cnt1 from tab3;
--select max(dt) into cnt1 from tab4;
--select max(dt) into cnt1 from tab5;if cnt1 > cnt2 then
DBMS_OUTPUT.PUT_LINE('cnt1 is the biggest');
end if;end;
/
因为ROWID的排序不是按照插入到表中的先后来排序的。