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;
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy