July 16, 2020 at 5:41 am
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:
SELECT *
FROM XYZ
WHERE
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
July 17, 2020 at 6:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 17, 2020 at 4:32 pm
I'd use a shell script.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply