So I basically have a spreadsheet with five columns of values. Each column represents a different field in my query.
For each row in the spreadsheet, I need to execute a query (Oracle) that uses the values from that row and store/output the results.
Example query for 1 row of the spreadsheet:
Row1.Column1 = XYZ.Column1 AND
Row1.Column2 = XYZ.Column2 AND...etc
In my case, I have over 1000 rows in the spreadsheet.
What would be the best way to accomplish this? Write a select statement for each row in the spreadsheet? Do some kind of PL/SQL block? Something else?
If writing a different select statement for each row in the spreadsheet is the way to go, I'll probably just write a shell script or use some Excel magic to create the select statements for me, so that's not necessarily an issue.
real estate digital marketing agencies builders and developers in dombivli new projects in dadar
- This topic was modified 6 months, 1 week ago by vilaskafre.