摘要： --创建过程create or replace procedure t asbegin insert into tian(id) (se_a.nextval); commit; end; --创建job,每天凌晨2点执行 declare job number; beginsys.... 阅读全文

摘要： create materialized view port refresh completestart with sysdatenext sysdate + 1/1440as with t as (select b.ename,b.sal, (select dname from scot... 阅读全文