Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert Statement

Re: Insert Statement

From: Henk Puister <henkp_at_mac.com>
Date: Thu, 28 Aug 2003 23:53:02 +0200
Message-ID: <henkp-C9D50B.23530228082003@nbnu.xs4all.nl>


In article <3722db.0308280854.78410c7f_at_posting.google.com>,  danielroy10junk_at_hotmail.com (Daniel Roy) wrote:

> That error message suggests that you have more columns in table A than
> in table B. Please confirm that these 2 tables really have the same
> number and types of columns.
>
> Daniel

And the columns must be in the same order for 'insert into B as select * from A'.

-- 
Posted by news://news.nb.nu
Received on Thu Aug 28 2003 - 16:53:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US