Re: Nested Table Query

From: joel garry <joel-garry_at_home.com>
Date: Tue, 11 Sep 2012 08:47:07 -0700 (PDT)
Message-ID: <f2ada3e3-b2d8-4c75-8841-06f6545b4eff_at_t9g2000pbc.googlegroups.com>

On Sep 11, 8:32 am, ddf <orat..._at_msn.com> 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.

jg

--
_at_home.com is bogus.
http://www.crn.com.au/News/315110,oracle-sues-partner-over-theft-claims.aspx

Received on Tue Sep 11 2012 - 10:47:07 CDT