It shows that the update was successful in sqlplus, but it is not actually updated

lyiner

Very strange problem, I used a statement
update QBA01 set qm='Five Districts',dm='One Team',zm='Southern Trinity' where rq>=TO_DATE('2017-01-01','yyyy-mm-dd') and rq<TO_DATE ('2017-01-02','yyyy-mm-dd') and jh='N90-23'
Prompt in sql*plus

1 row has been updated.

But when I looked at the database, there was no update.
Which brother can help

stone37

This problem is indeed. This phenomenon exists in both insert and update.
I don’t know the reason, haha
So I wrote a small program myself and put an edit to update the contents of the database.
You can also use sql scrapture (it seems to be misspelled) to update

slashf

Is there no commit;

aeoluseros

No commit;

wetday

There must be no commit

marceau543

Add a
commit;

陈奕城

commit ...

freelsq

......, the second floor actually said that there are problems with insert and update. If there are such BUGs, ORACLE will not work, ha ha

whbilly

Must commit; after that, you can select new data from oracle