Try something like this:
declare
cursor upd_cur is
select rowid row_id
from some_table
where status = 'X';
counter integer := 0;
begin
for upd_rec in upd_cur loop
update some_table
set status = 'Y'
where rowid = upd_rec.row_id...
When user A adds row to a table, the rows becomes available for user B to see only after user A issues commit command. If there is a trigger associated with insert operation against this table it will fire as part of transaction.
If you would like to capture data in the DataMart schema in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.