Forum Discussion

Karthikgs's avatar
Karthikgs
New Contributor
5 years ago

How to execute 20 different oracle sql queries using oracle execute snap

Hello Everyone, Need your expert advise, I have 20 different set of sql queries running on the same table to generate the metrics, I am trying to run through them using Oracle execute but got erro...
igormicev's avatar
igormicev
Contributor
5 years ago
Copy Link

Hi @Karthikgs,

If you’re selecting/generating data then the snap won’t support such a series of commands, but if the queries do update/delete/insert then you shouldn’t have issues.

So in order to overpass it, you can introduce a separate “Pipeline Execute” in which you’ll be executing the passed queries and save the result into a table in Oracle. Lastly, just query out the table(s) with the generated results.

/Igor