"scotty" <invalid-spammer_at_invalid.invalid> wrote in message
news:oiuhsuc5bad136clnn63bu357bq37j7bb6_at_4ax.com...
> >SQL> insert into customer(customer_id,surname,forename)
> >values(1,'SMITH','JOHN');
> >
> >1 row created.
> >
> >SQL> COMMIT;
> >
> >Commit complete.
>
> Ah COMMIT, haven't used that before. Maybe that was the problem?
If you never commit you will never get any data at all, as Oracle will just
rollback the transaction. Of course it makes managing storage requirements
somewhat easier :(. So smart alec remarks aside, yes it would be the lack of
a commit that was your problem.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Nov 06 2002 - 06:53:00 CST
