Re: Editing text with Oracle
Date: Mon, 10 May 1999 00:10:43 +0100
Message-ID: <7h54h2$q03$1_at_news4.svr.pol.co.uk>
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
Gloucester
UK
>Jérôme Poirier wrote in message <7h4tqi$hu8$1_at_vishnu.jussieu.fr>...
>Hello,
>
>I would like to update my Oracle database, according to datas which are in
a
>file.
>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
>--
>poirier_at_gla.ecoledoc.lip6.fr
>http://gla.ecoledoc.lip6.fr/~poirier
>
>
Received on Mon May 10 1999 - 01:10:43 CEST