Re: SQL scripts in Oracle

Somil Mittal wrote:
>
> Hello Everyone,
>
> There are a certain set of commands that I have to execute from time
> to time in Oracle. Does anyone know how I go about writing an SQL script
> or if you know any site where I could get this info...
>
> Thanks,
>
> Somil

Use Oracle's dbms_job and dbms_sql untilities. The dbms_sql allows you to execute almost any SQL command. The dbms_job untility allow you to schedule a job to run from time to time.

-- 
---------------------------
Bo Lu
Programmer/Analyst
Uiversity of Utah Hospital
bo.lu_at_m.cc.utah.edu
(801)-581-5964
---------------------------