So if an access plan is reused, a database server requires less CPU resources to execute the corresponding SQL statement repeatedly.
因此,如果一个访问计划被重用,则数据库服务器重复执行相应sql语句所需的CPU资源将减少。
When you execute a prepared statement, IDS now detects changes to underlying objects and re-prepares (re-compiles) the statement if needed.
当执行预编译语句时,IDS检测底层对象的变化,必要时重新准备(重新编译)语句。
If you want to test the SQL statement, press F5 to execute the script.
如果您想要测试sql语句,按F5执行该脚本。
If it is not assigned to a variable, or it is not otherwise used as part of the calling statement, then the shell will attempt to execute it rather than display it.
如果没有将该输出指派给一个变量,或者没有在别的地方将它用作调用语句的一部分,则shell将会尝试执行输出而不是显示输出。
Because of that, the if statement in this example says: "Execute the 'echo' only if there were errors."
正因为如此,这个例子中所陈述的if说:“只有当错误出现时才执行'echo '。”
You create a Statement to execute commands to drop and recreate the table, which allows you to reset the database from this program if it becomes corrupted.
创建一个Statement来执行删除和重新创建表的命令,这允许您在数据库受损时通过此程序重置数据库。
If none of the conditions are true, it will execute the "else" action, if one is present, and then continue executing lines following the entire "if, elif, else" statement.
如果没有条件为真,则将执行“else ”操作,如果有一个条件为真,则继续执行整个“if,elif, else ”语句之后的行。
Up to this point, you've seen how the if statement can be used to execute one of two blocks of program statements, depending on the value of a particular Boolean expression.
至此,已经看到了if语句可以如何用于根据一个特定布尔表达式的值,来执行两个程序语句块中的其中一个。
Remember that you execute the body of an if statement only if the expression is True, which for this expression happens when the variable I is not evenly divisible by 25.
记住,您只在表达式为True时执行if语句体。该表达式在当变量i不能被25整除时计算为True。
And if you want to create a table space named MY_SPACE1 in this database, simply execute a create TABLESPACE statement that looks like this.
如果您想创建一个名为MY _ SPACE1的表空间,只需执行如下所示的CREATE tablespace语句。
A script usually contains a sequence of statements. If there is more than one statement, the results appear one at a time as the statements execute.
脚本一般都是包含了一系列的语句。如果语句超过一条,每个语句执行的时候都会显示结果。比如下面这个。
Also note that the whenever statement means it won't attempt to execute the script if the connect fails.
还要注意的是每当语句意味着它不会试图如果连接失败执行脚本。
If a label value equals expression, execute its accompanying statement list.
如果标记的值等于表达式,则执行其相伴的语句列表。
If a label value equals expression, execute its accompanying statement list.
如果标记的值等于表达式,则执行其相伴的语句列表。
应用推荐