Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    5

    Unanswered: update to tables in sql*plus won't reflect when checking tables in oracle dba studio

    i added many new records to tables from sql* plus, but i could not see the change when checking the tables with the oracle dba studio. However, if I use 'select * from TablesNames' from sql*plus, I can see the change.

    could anybody tell me why? I'm using Oracle v8.1.7

    Thank you very much!

  2. #2
    Join Date
    Mar 2003
    Location
    Belgium
    Posts
    9

    Re: update to tables in sql*plus won't reflect when checking tables in oracle dba studio

    Originally posted by hssh
    i added many new records to tables from sql* plus, but i could not see the change when checking the tables with the oracle dba studio. However, if I use 'select * from TablesNames' from sql*plus, I can see the change.

    could anybody tell me why? I'm using Oracle v8.1.7

    Thank you very much!
    Have you done the commit ?

    Changes are not available for other sessions if you don't commit. Only for your current session.

  3. #3
    Join Date
    Mar 2003
    Posts
    5
    Yest, that's the reason, and now I have no problem with it.

    I'm new to oracle. Thank you very much for your reminding me.

Posting Permissions

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