I need import the value to insert in oracle query. So...
I have file (csv or txt is the same). I need read value x,y,z.. After I store that value and use that
in oracle query like this: select * form table where value in ('x','y','z').
How to do that?
thnx at all
Solved! Go to Solution.
mmm... I have the problem to do the first step.
How I can read and store the list of value inside the file?
After I can use tJavaRow?
The example of open file is like this: name = test.csv
without comma or other separator
Your suggest work. But I have 1 one problem. I change the file contains and I don't concatenate to have "'" or ",".
So, my file I have the follow text:
But after the query,in tLOGrow the output is just only 1 record and not 3 records.
I show you my print screen
In my oracle query I have: select * from table where idcase IN ("+context.variable+")
1rst, you have put 3 line in the input file but it seems (based on the capture), only 2 are read.
Can you print the context variable after the construction (add a System.out.println inthe tJavaRow)?
Sorry, I wrong the example. You right.
So... input file I have 3 records and in tJavaRow I wrote this: context.elenco = row1.val_id;