Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: [URGENT] autocommit
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