|
Code Listing 1: Creating a scheduler program
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM(
program_name=>'GENNICK.LOADCUSTOMERS',
program_action=>'begin
INSERT /*+ append */ INTO customer
SELECT * FROM customer_external;
end;',
program_type=>'PLSQL_BLOCK',
number_of_arguments=>0,
comments=>'Load new customers from an external table',
enabled=>TRUE);
END;
|