Re: data not saved after exiting SQL*Plus

From: Justin Cave <jocave_at_yahoo.com>
Date: 23 Sep 2002 00:07:26 -0700
Message-ID: <233b7a65.0209222307.4dcd1256_at_posting.google.com>


vk02720_at_my-deja.com (vk02720) wrote in message news:<4d814faa.0209221839.1b53d022_at_posting.google.com>...
>
> 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.

Every version of SQL*Plus has required that an explicit commit be issued before changes are committed. If you go through the Options menu, there is an autocommit option in SQL*Plus.

Justin Cave Received on Mon Sep 23 2002 - 09:07:26 CEST

Original text of this message