Re: Insert records from table 1 to table 2

Jay wrote:
> I have a table that I'de like to on a daily basis extract data from
> and load that data into another table. However, I need this process to
> take place automatically once each day. My Oracle database is on a
> Unix box. I know I will have to write SQL or PL/SQL, but what will I
> need to do to schedule my SQL to execute automatically once each day.
> I've seen places where they have used Cron to schedule batch jobs to
> run.
>
> Any suggestions or pointers to accomplish this task would help.
>
> Thanks,
>
> Jay

dbms_job package.

-- 
Regards, Frank van Bortel