Re: Content disappear...
Date: Fri, 7 Sep 2001 11:55:38 +0200
Message-ID: <3b98974b_at_news.vogel.pl>
Uzytkownik "Zhao" <coolshare_at_yahoo.com> napisal w wiadomosci
news:56275549.0109062129.373d2db9_at_posting.google.com...
> Hi, I am new to the SQL Plus of 8i.
> I brought up the SQL Plus and log on as a user to make the connection to
> either a database directly or OMS. Then, create a table and insert some
> items. As long as I didn't exit, I could see all the items in the table
> by "select...". But once I exited the SQL Plus and re-enter (as the same
> user) SQL Plus, the items inserted were gone!
Remember, that you need to commit your changes.
Once you enter a values to a table please issue command 'commit;' after
operation.
There is also auto-commit parameter in SQL*Plus enviroment. Set it to 'Yes'
if you wan't SQL*Plus to do commit for you, whenever you leave program.
Noel Received on Fri Sep 07 2001 - 11:55:38 CEST
