Re: Trimming blanks from VARCHAR2 columns

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 24 Nov 1998 15:20:28 GMT
Message-ID: <365cce73.6790704@192.86.155.100>

A copy of this was sent to "Izabella" <Izabella.Urbanek_at_afp.gov.au> (if that email address didn't require changing) On Tue, 24 Nov 1998 12:07:57 +1100, you wrote:

>You could set autocommit to 100, 1000 or whatever and your large update
>statement will commit every 100 or 1000 or whatever rows so that you won't
>run out of rollback segments.
>
>:-)

autocommit is set to either ON or OFF and causes a *statement* -- not the partial work of a statement -- to be autocommited (or not) in sqlplus. If an update updates 1,000,000 records -- autocommit will commit the 1,000,000 records -- not every N'th record...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Nov 24 1998 - 09:20:28 CST