Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.telusplanet.net!newsfeed.telus.net!xmission!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: Locking Multiple records Date: Tue, 11 Nov 2003 20:05:36 +0100 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <3nc2rvgcqmj5najiek0an0ruehpo3id1vt@4ax.com> Reply-To: postbus@sybrandb.demon.nl References: X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 15 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:133033 On 11 Nov 2003 02:29:17 -0800, runa_b@indiatimes.com (Runa) wrote: >Is there anyway in which I can lock multiple records together, but >release the lock one at a time i.e commit changes to one record at a >time? > >Thanks. >Runa No there isn't, as this would violate the basic concept of a transaction. -- Sybrand Bakker, Senior Oracle DBA