Re: match columns on insert sub select

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 03 Aug 2003 17:07:52 +0200
Message-ID: <k89qivsh4d7q1hgor7aq3o5ugaom3e1tj3@4ax.com>

On Sun, 3 Aug 2003 13:30:54 +0200, "Umberto Quaia" <umberto..quaia_at_tin.it> wrote:

>I don't understand Erik's objection about adding a column in
>source table.
>If that column is not in dest table, it's simply not copied.

In PL/SQL stored procedures the * is resolved at *compile time*. This means when you change the table the procedure won't work anymore.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Aug 03 2003 - 10:07:52 CDT