Re: PL/SQL - is inserting of %ROWTYPE variable possible?

Hans van Dam wrote:
<snip!>
>
> As you might know you can skip the first column-list (only when
> inserting all columns), like this:
> INSERT INTO tab VALUES (rec.a, rec.b, rec.c, rec.d, rec.e);
>

Bad programming habit! If the table ever changes (e.g. a column gets added) the OP way of programming would still work; yours not.

Frank Received on Sat Jan 11 2003 - 11:17:58 CST