scheduling an update query , how

[blom0344]

Due to a bug in application I have to manually update records with an empty status field to value '00'. Very simple SQL, very fast, no problem. I want a way to either schedule this statement or find a way to fill in default '00' values for newly created records.....
Any ideas.... T. Blom
Information analyst
tbl@shimano-eu.com

 

[sem]

You may:

define default value for a field
or
write a trigger
or
do it in a batch mode from dbms_job

 

[blom0344]

Hello Sem,

The situation is a bit more complicated , cause the application runs on a database which we bought as a complete package. Rebuilding tables or other DBA type of actions is not something we can just do if we please, in order to keep support from Vendor. Is there a way to schedule something using the GUI tools of the administration client (Enterprise Manager and such ...)? T. Blom
Information analyst
tbl@shimano-eu.com

 

[sem]

Using DBMS_JOB does not require administration actions (besides setting job_queue_processes and job_queue_interval) or rebuilding tables. It's just embdedded Oracle scheduler. Apparantly, you may use some kind of external scheduler, like cron or at, but for your specific purpose DBMS_JOBS looks like a better solution.

 

[DoubleH]

DBMS_JOB will be a better solution for this problem. Using cron or at for updating one simple column is not necessary. Is it possible for you to give alter table command, then using that you can set the default automatically which will be the best solution for your case. Thanks & Regards,
DoubleH

 

[sem]

DoubleH: default value may help, if mandatory value is missed, it will not change NULL value inserted.

 

[blom0344]

Sem & DoubleH,

I came up with DoubleH' idea of default value yesterday and proposed it to the Vendor. He agreed, so I issued the alter table command. Seems to work properly.......... T. Blom
Information analyst
tbl@shimano-eu.com

 

[DoubleH]

Hi,
As Sem had mentioned, also issue update on the column where column value is null.
Thanks & Regards,
DoubleH