Re: %ROWTYPE question

rory_at_falcon.inetnebr.com (Rory Reynoldson) wrote:
>
>
>
> Quick question:
>
> I am selecting data into a rowtype variable, and modifying it
> slightly, at which time I want to insert it as a new row. What is
> the syntax? I've tried the obvious (to me) without much luck.
> I'm doing this remotely with no manuals so am unable to look it up.
>
> Thanks!
>
> Rory Reynoldson
> rory_at_inetnebr.com

say for example your rowtype var is p_rec then use the following:

insert into table

            col1,
            col2..
values
            p_rec.col1,
	    p_rec.col2..;