Auto update a column every 24 hours in Oracle database I want to reset the values of a column every 24 hours. Is it possible? The column contains numeric values.

It's a ticket reservation system. I need to reset the number of tickets.
Sure, just create a job. For example, update column every midnight:

begin
  dbms_scheduler.create_job
  (
   job_name             =&gt; 'UPDATE_TABLE',
   job_type             =&gt; 'PLSQL_BLOCK',
   job_action           =&gt; 'begin update table set column = value; commit; end;',
   start_date           =&gt; trunc(sysdate+1),
   repeat_interval      =&gt; 'FREQ=DAILY;BYHOUR=0;BYMINUTE=0',
   enabled              =&gt; TRUE,
   auto_drop            =&gt; FALSE
  );
end;
/