Re: Commit for insert into table .... select ....

A copy of this was sent to yewpc_at_rnd.celcom.com.my (if that email address didn't require changing) On Fri, 10 Dec 1999 00:54:17 GMT, you wrote:

>Hi,
>Can anyone tell me can if it is possible to have
>insert into table_a select * from table_b statement to include a commit
>at certain internal ?
>
>As for import we can set commit=y how about insert ... select ?
>if it is possible than how ? else I may need a stored procedure to
>control the number of records to be committed this is what i not plan
>to do.
>Please let me know if you have any suggestions.
>Thank you

if you are using SQLPlus -- see the SQLPlus copy command -- it can do this for you....

>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Dec 10 1999 - 15:55:13 CST