Home » SQL & PL/SQL » Client Tools » iSQL*plus of Oracle 10g
icon9.gif  iSQL*plus of Oracle 10g [message #144022] Mon, 24 October 2005 13:07 Go to next message
Messages: 1
Registered: October 2005
Junior Member
I just tried using iSQL*plus of Oracle 10g to execute SQL commands, e.g.,insert into numbers values(9999,1243,6666); where numbers is the table name. After execution, the screen showed "1 row created.". However, i back to the Enterprise Manager and view data of this table called numbers, the new record doesn't show there at all. So, I logged out EM and logged into it one hour later, the new record (9999,1243,6666)appears in the table!!! Why so late!

Could you please help me with this? Thanks.

Re: iSQL*plus of Oracle 10g [message #144105 is a reply to message #144022] Tue, 25 October 2005 01:45 Go to previous messageGo to next message
Messages: 7062
Registered: December 2001
Senior Member
Did you commit immediately after insertion of the row?

Re: iSQL*plus of Oracle 10g [message #144124 is a reply to message #144105] Tue, 25 October 2005 03:23 Go to previous message
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
This is to do with read consistency. If you perform DML on a table, but do not commit that transaction, then other sessions will not be able to see it. You EM session is a different session. When you logged outr of your main session it performed a commit, thereby making that new row available to 'all and sundry' hence the end result that you saw.
Read up on read consistency in the Oracle docs.
Previous Topic: TOAD GUI question - what is the red block for
Next Topic: running sql plus worksheet as test user
Goto Forum:

Current Time: Tue Aug 04 15:46:35 CDT 2020