Hi all,
This is my oracle scheduler
begin
dbms_scheduler.create_job
(
job_name => 'streams_heartbeat_job',
job_type => 'PLSQL_BLOCK',
job_action => ' insert into a values(12);',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=secondly; interval=15',
enabled => TRUE,
comments => 'Streams heartbeat job from site A'
);
end;
here i am inserting some value in to table 'a'
but i need to read 'b' table data and i need to inert the values in 'a' table.
Please any one help me.
thanks,
Malleswari.
|
| Author: D.Jeya kumar(JK) 29 Aug 2008 | Member Level: Diamond | Rating:  Points: 4 |
Hi,
Insert into aSelect * from b
begin
dbms_scheduler.create_job
(
job_name => 'streams_heartbeat_job',
job_type => 'PLSQL_BLOCK',
job_action => ' Insert into aSelect * from b ;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=secondly; interval=15',
enabled => TRUE,
comments => 'Streams heartbeat job from site A'
);
end;
Regards
JK
|