Re: PL/SQL - is inserting of %ROWTYPE variable possible?
From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 11 Jan 2003 18:17:58 +0100
Message-ID: <3E2051C6.4000000_at_netscape.net>
Date: Sat, 11 Jan 2003 18:17:58 +0100
Message-ID: <3E2051C6.4000000_at_netscape.net>
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 - 18:17:58 CET