All geek questions in one place

Need help understanding the difference between script format and request

This is a very new question, which I'm afraid of ... I was wondering if there are people here who can tell me what the difference is between SQL scripts and SQL queries (I accidentally used these terms interchangeably for too long).

I have a lot of experience in query execution (SQL server, oracle, postgres), but I started working with a group that requires me to send scripts with the specified SQL queries through their department for verification and directly told me not to send their queries, but the scripts. Can someone explain the difference to me?

If that matters, the SQL query I need to send just merges the fields from four tables together into one.

Thanks in advance if anyone can help me with this!

+4
source share
2 answers

In this context, it seems that they want to see any set of commands that will change (INSERT, UPDATE, DELETE data, etc.) and are not related to the queries that you run to simply return or view the data.

I suspect that more people use these terms interchangeably than you think.

It is a good idea to return to this department without sympathy and ask for clarification, as different teams use different terms. I think you will find that they are asking you to plan ahead any actions to modify the data, to sequentially place your commands in a file (for example, a .sql file if you work in a management studio, etc.) and send this file to them for review.

Asking around was a great move. You cannot be too careful with these things!

+4
source

The request consists of one team. A script is just a file with a bunch of requests.

See: http://docs.oracle.com/cd/E14373_01/user.32/e13370/sql_rep.htm

+4
source

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

More articles:


All Articles