Hi All ,
I am new in Oracle form , I have a query ,
in oracle from(10G) i am showing a whole table , now when i update any row then in that same row there is a column named as Status , must got update automatically with value 'NEW '
Can any one help me how to perform this task .
If any body know then please do reply ASAP .
/* write the following code in Post-Text-Item at Block Level */
IF :System.Record_Status IN ('CHANGED', 'INSERT') THEN
Use something like
in a WHEN-DATABASE-RECORD-trigger at your block