Re: Nested Table Query

From: joel garry <>
Date: Tue, 11 Sep 2012 08:47:07 -0700 (PDT)
Message-ID: <>

On Sep 11, 8:32 am, ddf <> wrote:

> SQL>
> SQL> insert into hr_info_cpy
>   2  select * from hr_info;
> 1 row created.

Somehow that strikes me as "considered bad practice." The order of columns, like anything else without explicit ordering, is not guaranteed. Try adding columns a and b to the first table, b and a to the second, and see if those are selected into the correct place. Any modification of either table could potentially do this.


-- is bogus.,oracle-sues-partner-over-theft-claims.aspx
Received on Tue Sep 11 2012 - 10:47:07 CDT

Original text of this message