how to direct select output to insert input

[Net Llama!]

i've got an Oracle (9i, if that matters) problem.  i need to essentially 
copy all the data from a single column (call it a) in a table into a 
different column (call it b) in the same table.  both a and b are the 
same datatype, and b is currently empty.  i've tried the following, but 
it fails:
insert into table_foo (b) values ((select a from table_foo));

i think the problem is that its attempting to insert all the rows from a 
into a single row of b.  i just don't know how to work around this. 
anyone have any ideas or suggestions?  thanks!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    [EMAIL PROTECTED]
Linux Step-by-step & TyGeMo:                    http://netllama.ipfox.com
  5:40pm  up 18 days, 18:10,  3 users,  load average: 0.49, 0.18, 0.11

_______________________________________________
Linux-users mailing list
[EMAIL PROTECTED]
Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users