SQL plus running multiple queries

I have 12 requests to run, but cannot work at the same time. I would like to start the first request, then as soon as it finishes, the next request will start, when it completes the third request and so on. Want it to be automatic. Each request writes a txt file. Thanks

+3
source share
2 answers

It seems to me that you just need to create a script and call the script:

@query1.sql
@query2.sql
...

Or am I missing something?

+2
source

Insert them all into 1 file using the GO statement between them to do the trick.

0
source

Source: https://habr.com/ru/post/1767874/


All Articles