Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
update with commits at certain counts
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...- ElenaS
- Post #2
- Forum: Oracle: All versions
-
Understanding Oracle Trigger Process
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...- ElenaS
- Post #2
- Forum: Oracle: All versions
