posted 15 years ago
Hello,
I have a simple Oracle 10g update statement I run in SQL developer.
I try to issue an update, followed by a commit, followed by a SELECT statement on what should have been updated.
I find that the SQL statement below I run after the commit does show the new value, but if I shut down SQL Developer and re-start it, then I see that nothing was actually committed.
Oracle gives me the time it took to run the statement with no errors.
The syntax is like this:
Update users set field1="some value", set field2="another value", ..... where userid="12345" ;
commit;
select * from users where userid ="12345";
--------------
Any ideas why this doesn't do the commit as expected?
Thanks.
-- Mike