Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002

    Unanswered: Disappeared data

    Hi There;

    I just inserted 5 rows into a table, and I was able to see the rows by using count(*) function.
    But if I open second sqlplus window and login as same user, the result of count(*) is 0.
    I only can see the inserted rows in the first window, if I close it, nothing will be left, I have to do insertion again.

    What is the problem I am having? Any hint?
    Thanks in advance!

    Last edited by Tina; 10-08-02 at 16:42.

  2. #2
    Join Date
    Feb 2002
    Are you afraid to commit ?

    Anyway, it sounds like the transaction is not being committed. Check it out and let me know.

  3. #3
    Join Date
    Mar 2002


    your insert transcation isn't commit , if you want to see you 5 rows
    send SQL command
    set isolation to dirty read;
    select * from xxx;
    you can see uncommit row

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts