chani wrote:
> Hi,
>
> This may be another horrible idea.
>
> ** Is There any way to auto update columns of database table.
> ==============================================================
>
Yes, you wold write a procedure to do the work, and
use a job for the timing.
If you're on 10g, use dbms_schedule, it knows stuff like
"every last Friday of the quarter, run this job"
On 9i or earlier, dbms_job does the trick, but the
interval (when is it the last Friday of a quarter?)
calculation is for you to perform
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Apr 12 2006 - 12:52:29 CDT
