Re: %ROWTYPE and INSERT

In article <32e3382d.3937421_at_news.via.at>,

   dtr_at_leadingbits.via.at (Dieter Oberkofler) wrote:
>Unfortunately it is not possible to use the same %ROWTYPE
 variables
>for INSERT and UPDATE statements that affect all columns of a
table.

That's true, but you can do this, if you declared

	cursor C is select * from T;
	R C%rowtype;
then you may write:
	insert into T (select * from T) values ( ... )

Dave Mausner, Managing Consultant, Braun Technology Group, Chicago. Received on Mon Jan 20 1997 - 00:00:00 CST