how to handle insert and update on same record before transaction commited
411499Apr 21 2004 — edited Apr 23 2004hi all.
in oracle store procedure, may i execute a update sql statement after insert statement(the transaction be uncommitted) on same table and same record, like follow:
insert stmt:insert test(a,b,c) value (1,2,3);
update stmt:update test set b = 3 where a= 1;
but the update statement is invalid , and has it errow ?