sql query using csv data
Posted on 2015-01-09
I have a csv file like below
Now i wrote a sql query like below
select * from emp
where emp_id = '1000001' and jdate = '20110101'
this is for one member but is there a way to write a query for all the values in the csv.
if i use my query then i need to feed empid, jdate to the query and the DB is called lot of times.
but can I avoid it and make one single call for all the values in csv and still get output.
I am using perl script to call the stored procedure where the above query is written