Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Update query

Update query

From: Paulos <Nospam_at_none.com>
Date: Thu, 6 Oct 2005 20:21:35 +0200
Message-ID: <43456ae2$1@news.vo.lu>


I know this is pretty elementary stuff but I was trying to do a update today something along the lines of

update T1
set T1.somecol = T2.someothercol
where T1.Anothercol = T2.Anothercol

where T1 and T2 are tables

Can this be done ...what am I missing here?

TIA Paulos Received on Thu Oct 06 2005 - 13:21:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US