Re: Insert record into table

Buddy Taylor wrote:
>
> Can I INSERT a record without listing all of the columns?
>
> e.g.,
>
> a_rec a_cur%ROWTYPE ;
>
> INSERT INTO a_table(*)
> VALUES(a_rec) ;
>
> I'm just guessing here what the syntax might look like.
>
> Buddy Taylor buddyt_at_renewal-iis.com

Look at the SQL*Plus COPY command. It makes copying a table easy, and allows you to take occasional commits. I just posted a lengthy note in comp.databases.oracle.misc with an example, or you can look in the SQL*Plus reference manual.

-- 
Bob Swisshelm
Eli Lilly and Company
nospam.swisshelm_at_lilly.com  
(remove 'nospam' if you want to send mail to me)