日期:2014-05-16 浏览次数:22127 次
create or replace procedure abssf as
begin
INSERT
INTO sc_jc_rm
(
sc_jc_rm.bl_id,
sc_jc_rm.bl_name,
sc_jc_rm.fl_id,
sc_jc_rm.rm_id,
sc_jc_rm.rm_name,
sc_jc_rm.area_rm,
sc_jc_rm.rm_cat,
sc_jc_rm.rm_type,
sc_jc_rm.dv_id
)
SELECT rm.bl_id,
bl.name,
rm.fl_id,
rm.rm_id,
rm.name AS abc,
bl.area_rm,
rm.rm_cat,
rm.rm_type,
rm.dv_id
FROM rm,
bl
WHERE rm.bl_id = bl.bl_id ;
end
variable job1 number;
begin
dbms_job.submit(:job1,'abssf;',sysdate,'sysdate+1');
end;
select * from user_jobs where what = 'abssf;'