Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Default Values
"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
![]() |
![]() |