Re: Needed help on FILE --> PL/SQL table Manipulation

One way would be:
Load the flat file into a table (using sqlloader). Create a PL sql program to select data from this table and do the necessary (compares with the database table for certain conditions), using cursors. Use dbms_output to print the necessary records (If the condition passes then those records should be written to another file). Use this final file to (where further processes will be held in Unix script) Truncate the temporary table you created.

Hope this helps.
PT
"vikram" <vikram_at_wanadoo.fr> wrote in message news:9eub52$21j$1_at_wanadoo.fr...
> Hi,
>
> Can U suggest or guide me on the following task.
>
> I need to import from a flat file 'Well delimited by ;' into a pl/sql
 table
> for further manipulations. Is there any way to do that efficiently (at
 the
> most avoiding utl file technic.).
>
> To explain in detail,
>
> I have a file which contains 3 cols 'ofcourse datas delimited by ;'. Now
 I
> want to run a plsql script that reads from the file into a pl/sql table
 and
> compares with the database table for certain conditions. If the condition
> passes then those records should be written to another file where further
> processes will be held in Unix script.
>
> Is there any simple way or what method shall be quiet simpler.
>
> The records in the file is approximately about 10000 lines.
>
> Thanks in advance.
>
>
>
>
>
Received on Tue May 29 2001 - 08:43:26 CDT