Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: [URGENT] autocommit

Re: [URGENT] autocommit

From: johnsonlu <johnsonlu_at_ms30.url.com.tw>
Date: 2000/08/13
Message-ID: <8n63r0$2qc@netnews.hinet.net>#1/1

hi
  you can set parameter in sql*plus environment!! Matt B. ¼¶¼g©ó¤å³¹ ...
>"Markus Schwabe" <mschwabe_at_gscout.de> wrote in message
>news:8n16eu$2q1e$1_at_koroth.muc.eurocyber.net...
>> AFAIK you can set autocommit only in SQL*Plus and only for this session.
>> At the SQL-Prompt, type:
>> "set autocommit on"
>
>You can do it for all SQL*Plus sessions but offhand I don't remember where
 it
>is - it's either in a database file, like init.ora, or in a setup file for
>SQL*Plus. I know all our sessions that we have always have this turned on
>automatically for us.
>
>-Matt
>
>
>
>
Received on Sun Aug 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US