create table x(c1 number,c2 number); create table y(v1 number,v2 number,v3 number,v4 number); insert into y (v1,v2) select c1,c2 from x;
or better you can use the alter table command on your old table (here x) alter table x add v3 number; alter table x add v4 number; the following way doesn't seem to work for me alter table x add (v3 number,v4 number); Regards, Lloyd On Tue, 2007-06-05 at 11:25 +0530, Kirrthana M wrote: > Hi all, > I have created a table with two columns c1 and c2 and inserted some > values into,in future i may include some additional columns c3,c4..... to > the same table.In tat case i should not loose my data in the current > table,so i should be able to copy the content of the current table(values of > c1 and c2) to the new table and start working with the new table and delete > the existing one,could anybody give me a suggestion for doing this. > > Regards > Kirrthana ______________________________________ Scanned and protected by Email scanner ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
