inserting values from source table to taarget table
693309Apr 9 2009 — edited Apr 9 2009Hi all,
I have source table with 5 fields and target table with 8 fields,how can i filldata from source to target table,
i am using the below syntax..but it throws me an error od ora-00936,please tell me where i am doing wrong ..as
i am new and have got very little knowledga ..so please bear me ..
INSERT INTO XYZ2 A VALUES
(SELECT * FROM XYZ B)
( WHERE B.A=A.AA AND
B.B=A.BB AND
B.C=A.CC AND
B.D=A.DD) ;
in the above code i am trying to fill target table xyz2 from source table xyz where i am doing wrong...in case if i
have a field in target table where the value of the filed should be same entire table ..how should i code it..please help me....
Thanks,
MIKE