Re: Newbie Question

[Quoted] Hi Jérôme,

That did it. Thanks! I guess that I will have to get a good book on Oracle.

Gary

"Jérôme PERRET" <jperret_at_freesurf.fr> wrote in message news:9325fk$rf1$1_at_wanadoo.fr...
> Did you commited after inserting ?
> Try to insert data with SQL*Plus the type :
> commit;
> You sould have you inserted values visible in Schema manager data editor
 and
> external application after that.
>
> Jérôme
>
>
> Gary J. Groomer <gary_at_designfirst.com> a écrit dans le message :
> hD056.5136$3t2.195047_at_newsread1.prod.itd.earthlink.net...
> > 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
> >
> >
>
>
>
Received on Thu Jan 04 2001 - 17:45:20 CET