Re: data not saved after exiting SQL*Plus
From: Dan Sumner <dan_sumner_at_europ-assistance.co.uk>
Date: 23 Sep 2002 03:24:11 -0700
Message-ID: <c259012e.0209230224.54c5fa45_at_posting.google.com>
Date: 23 Sep 2002 03:24:11 -0700
Message-ID: <c259012e.0209230224.54c5fa45_at_posting.google.com>
There should be a setting in SQL*Plus that performs an implied commit when you exit. Try setting the autocommit on the options..environment pull down menu.
> Hi,
>
> I am working on Oracle 8i Personal edition on Win 98.
> I inserted some rows in a table and quit out of SQL*PLus. The data was
> not saved. Do I have to explicitly issue a commit after each insert ?
> I have worked on prior versions or Oracle and did not have this
> problem. Is this version different or is there some option in SQL*Plus
> that I need to set.
>
> TIA
Received on Mon Sep 23 2002 - 12:24:11 CEST