Re: Editing text with Oracle

From: Simon Hedges <>
Date: Mon, 10 May 1999 00:10:43 +0100
Message-ID: <7h54h2$q03$>

Oracle has a utility, SQL Loader, which will load a text file into a table.

If you want to do cleverer updating (e.g. comparing the text fil with what is already in the table, and then updating/inserting/deleting rows as appropriate), you will need to load the load into a temporary table and then use PL/SQL to do the comparison.

This is the solution using Oracle's basic utilities - there may well be other tools.

Simon Hedges

>Jérôme Poirier wrote in message <7h4tqi$hu8$>...
>I would like to update my Oracle database, according to datas which are in
>So, I have to parse this file to extract informations I need.
>Is there a tool/langage in Oracle 8 for doing that ? Can forms4.5 do this ?
>Thank a lot
>Jerome Poirier
Received on Mon May 10 1999 - 01:10:43 CEST

Original text of this message