Where current of statement is not updating correct row oracle

Rated 3.90/5 based on 908 customer reviews

UPDATE dest_tab tt SET (tt.code, tt.description) = (SELECT st.code, st.description FROM source_tab st WHERE = tt.id) WHERE EXISTS (SELECT 1 FROM source_tab WHERE id = tt.id); 5000 rows updated.

SQL ----------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------------------- | 0 | UPDATE STATEMENT | | 4999 | 185K| 30013 (34)| | | 1 | UPDATE | dest_tab | | | | | | 2 | NESTED LOOPS SEMI | | 4999 | 185K| 19 (6)| | | 3 | TABLE ACCESS FULL | dest_tab | 10000 | 332K| 18 (0)| | |* 4 | INDEX UNIQUE SCAN | source_tab_PK | 2500 | 10000 | 0 (0)| | | 5 | TABLE ACCESS BY INDEX ROWID| source_tab | 1 | 43 | 2 (0)| | |* 6 | INDEX UNIQUE SCAN | source_tab_PK | 1 | | 1 (0)| | ----------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 4 - access("ID"="TT"."ID") 6 - access("ST"."ID"=: B1) UPDATE (SELECT tt.id, tt.code, tt.description, AS st_code, st.description AS st_description FROM dest_tab tt, source_tab st WHERE = st.id) ilv SET = ilv.st_code, ilv.description = ilv.st_description; 5000 rows updated.

The record locks are released when the next commit or rollback statement is issued.

The Oracle NEXTVAL function is used to retrieve the next value in a sequence.

where current of statement is not updating correct row oracle-83

where current of statement is not updating correct row oracle-71

where current of statement is not updating correct row oracle-15

You can compile a positioned update even if the cursor has not been opened yet.

A searched update statement depends on the table being updated, all of its conglomerates (units of storage such as heaps or indexes), all of its constraints, and any other table named in the WHERE clause or SET expressions.

A CREATE or DROP INDEX statement or an ALTER TABLE statement for the target table of a prepared searched update statement invalidates the prepared searched update statement.

However, removing the open cursor with the JDBC method invalidates the positioned update.

A CREATE or DROP INDEX statement or an ALTER TABLE statement for the target table of a prepared positioned update invalidates the prepared positioned update statement.

Leave a Reply