Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert Statement
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.nuReceived on Thu Aug 28 2003 - 16:53:02 CDT
![]() |
![]() |