Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: update
On Thu, 18 Jun 1998 16:14:43 GMT, chris_at_ultramedia.co.uk wrote:
>How can I get the following to work?
>
>update table2
>set ref_ID =
>select ID_let||ID_num from table1;
update table2
set ref_id = (select id_let || id_num from table1);