Re: Insert record into table

 You can " insert into a_table select * from another_table ".

Buddy Taylor wrote in article <01bcb3d5$3fbf5140$a095cdd0_at_ntw-25>...

>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
>
Received on Fri Aug 29 1997 - 00:00:00 CDT