Remote use of SQLPLUS: Open files for read/write
I would like to extend an existing sql-script that I run from my SQLPLUS client (V12.1.0.2.0)on my Windows 10 workstation connected to a Linux Oracle cluster (V11.2.0.4.0 and V12.1.0.2.0).
In extending my script I would like to open a text file residing on my Windows10, read it and assign its value within a loop to a variable used in a query. The result should be written to a new file (created or overwritten).
In datail:
Table "doctaba" has two attributes: f_docnumber and f_docclassnumber. I have a textfile of about 12 million values of f_docnumber and want to have an output file with the associated f_docclassnumber.
0