执行语句或运行脚本？ [英] Execute Statement or Run Script?

问题描述

在Oracle SQL Developer中输入SQL语句时，我注意到我有两个选择。我可以执行语句或运行脚本。类似的选择似乎也可以在SQL Maestro中，除了命名为执行查询和作为脚本执行。

While entering an SQL statement in Oracle SQL Developer, I noticed that I have two choises. I can either "Execute Statement" or "Run Script". A similar choise seems to be available in SQL Maestro as well, altough named "Execute query" and "Execute as script".

这两者之间的区别是什么？

What exactly is the difference between the two?

推荐答案

运行语句将给出可排序表中所有结果的列表。它还将只运行光标下的语句（或突出显示）。当您运行语句时，系统将提示您输入绑定变量（位于其前面的任何占位符）。

Run Statement will give you a list of all the results in a sortable table. It will also only run the statement under the cursor (or highlighted). You will be prompted for bind variables when you run the statement (any place holder with : in front of it).

例如。

select * from customers where customer_id = :id

将提示输入id

运行脚本的值将执行工作表中的所有语句，并给出结果的文本读数。它不会提示您输入绑定变量的值。

Run Script will execute all statements in the worksheet, and give a text readout of the results. It will not prompt you for the values of bind variables.

这篇关于执行语句或运行脚本？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！