That's not the way it should work. After you run the INSERT you should be able to do a SELECT, and see the records in table A. Other sessions will NOT see those records in TABLE A until you do the commit.
I am guessing that you've got multiple sessions open (multiple sqlplus windows or multiple sql developer windows) and that your results are due to testing from different sessions. Make sure you are issuing all of your commands from the same session (window). Mike On Wed, Apr 27, 2011 at 8:15 AM, Dom <dolivas...@gmail.com> wrote: > I'm new to Oracle -- I've always used SQL Server, with autocommit > turned on. My problem is the following two statements: > > 1. insert into TableA (select * from TableB where rownum < 10); > 2. commit; > > After I do the first, I can see the records TableA. Then I do the > second command, and suddenly the records disappear. Any ideas? > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
