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: update with an external file

Re: update with an external file

From: metzguar <urs_at_ursmetzger.de>
Date: 13 Sep 2006 03:04:38 -0700
Message-ID: <1158141878.313599.69760@d34g2000cwd.googlegroups.com> 





M. Ostertag schrieb:



> Hello,

>

> I want to update a field in a table with an external text-file.




Load the text file as an external table.



http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2448



Then


UPDATE zeichnungen


SET ... = ...



WHERE id IN (SELECT id FROM external_table)



Hth 


Urs
Received on Wed Sep 13 2006 - 05:04:38 CDT












Original text of this message













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