This discussion is archived
13 Replies Latest reply: Feb 8, 2013 9:13 AM by jgarry RSS

Reg: Monitor a row of a table based on updated time.

Madhu.149 Newbie
Currently Being Moderated
Hello All,

Oracle Database 11g SE1 11.2.0.1

I have a table by name BANK_RESPONSE

Colums:
AMOUNT
UPDATED_TIME
STATUS (Default 0)


Whenever a new row is inserted to the table BANK_RESPONSE, I need to monitor that row, and after 30min of row insertion, if the STATUS is 0, then I need to change that value to 2. If the status is other than 0 then no modification to that column.


Thanks,
Madhu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points