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

    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!

    Tina

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Are u sure you're not inserting into a temporary table?
    Did you do a 'commit' after the inserts?
    rws

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I'm sorry, I didn't see Tina posted two times...
    rws

Posting Permissions

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