Re: Newbie Question

Hi Gary,

Depending on how you accessed these various sessions, this behavior could be expected. If you don't COMMIT the inserts, only the session that performed the insert can see the changed value..everyone else sees the committed rows in the table (before you started the transaction with the inserts)..
Some of these interfaces you mention will automatically commit when you exit..so, depending on the order you started up or shutdown the different tools you might see changes in one interface only, or in more than one (if the data was committed)

In SQL*Plus for instance, just type the word COMMIT at the prompt after the inserts are done..you'll get a message that says 'Commit Complete'..then you'll see the new rows from any other tool.

Hope this helps,

Steve

In article <JE056.5148$3t2.195214_at_newsread1.prod.itd.earthlink.net>,   "Gary J. Groomer" <gary_at_designfirst.com> wrote:
> I just installed Oracle 8i Personal Edition on my computer for local
> development and testing. I ran into a strange problem with the first
 table
> that I created.
>
> I opened the SQL* Plus Worksheet and ran a script to create a simple
 table
> and insert data into it. I used a SQL SELECT * to view the data and
> everything appeared as expected. Then, I tried to access the data
 from an
> external application and then from the Oracle Schema Manager and no
 data
> showed up. Then, I added some data, manually, with the Schema
 Manger's Data
> Editor. The newly added data showed up in the Schema Manager Data
 Editor
> and the external application, but not the data inserted previously
 with SQL*
> Plus Worksheet. Next, I went to the SQL* Plus Worksheet and ran a SQL
> SELECT * and the old and the new data showed up. Why isn't all of the
 data
> showing up in the Schema Manager Data Editor and the external
 application?
>
> Keep in mind that I have yet to create any new views and/or new users.
 I
> logged into the Schema Manager as system/manager and the SQL* Plus
 Worksheet
> as scott/tiger. Any help would be greatly appreciated.
>
> Gary Groomer
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 11:04:44 CST