I am looking for a java sample example which reads excel or text file and
iterate through the records by forming hash map or other object. Forms a query and queries againest oracle database
and generates excel report of any missing records compared to excel/ text file records.Emails the missingrecords report.
I saw this example
But it is not complete on what I was looking. It is inserting instead of 'select' to check missing records.
It mentioned like
rt into login(username,password) value('"+username+"','"+pa
is login is the name of the table with columns names username,password in the paranthesis?
Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance