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

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie: Update Table A from criteria in Table A

Re: newbie: Update Table A from criteria in Table A

From: Remington <remxub_at_earthlink.net>
Date: Mon, 3 Aug 1998 23:23:24 -0500
Message-ID: <6q62ck$53a$1@birch.prod.itd.earthlink.net> 





How about the following updating script?




Update tableA set tableA.field2=tableB.dif_field1 where
tableA.field1=tableB.field2



I have never tried myself so it doesn’t necessarily work.





Received on Mon Aug 03 1998 - 23:23:24 CDT












Original text of this message













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