Insert into <superset> table select * from <subset> table
655559Aug 18 2008 — edited Aug 20 2008Hello ...
I am using oracle 9i. I have two tables, say A and B as follows:
A has 100 columns A1 .. A100
B has 25 columns B1 .. B25
Data type in all columns in B are the same with A.
I want to insert/append all records in B into A.
I have tried (but failed) using the following:
insert into A select * from B
One time I tried to get all columns in in B, and concat it to be used as my "condition" in my sql statement, using plsql, but again, it stuck after the first 255 chars.
Any idea?
Thanks in advance.