-
instead of trigger
Hi Can some one help in writing a instead of trigger on this cursor so that i can update my view
Declare
cursor j1 is select min(jh.created_date) mindate, jh.job_id
from jobs@psn3 j, job_history jh, stages s
where s.system_stage_id=8 and
JH.JOB_ID=J.JOB_ID AND
JH.STAGE_ID=S.STAGE_ID group by jh.job_id;
Begin
for jobrdate in j1 loop
update v_jobs v
set returned_date = jobrdate.mindate
where v.job_id = jobrdate.job_id;
end loop;
COMMIT;
dbms_output.put_line('returned date has been update');
End;
Your help is much appreciated
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|