它是公平地说,标签一个循环是唯一有用的方式,可以使用标记语句。
It is fair to say that labeling a loop is the only useful way that a labeled statement can be used.
REOPT绑定选项将影响其中包含参数标记或主机变量的语句的优化。
The REOPT bind option affects the optimization of statements that contain parameter markers or host variables.
某些情况下,如果语句包含主机变量、参数标记或特殊寄存器那么访问路径在运行时的性能不会很好。
In some cases, the access path does not perform well at runtime if the statement contains host variables, parameter markers, or special registers.
一旦应用程序变量被绑定到某个参数标记,这种关联就会一直保持下去,直到相应的语句句柄被释放。
Once an application variable is bound to a parameter marker, the association remains until it is overridden or until the corresponding statement handle is freed.
所有主要数据库接口都提供执行包含参数标记的sql语句的功能。
All major database interfaces offer the capability of executing SQL statements that contain parameter markers.
语句可以有多个参数标记(' ? ')。
如上节所述,sql语句中的参数标记使用可促进访问计划重用。
As the previous section described, parameter marker usage in SQL statements fosters access plan reuse.
sql语句可能包含参数标记。
要实现访问计划重用,使用一个参数标记重写SQL语句,如 清单3 所示。
To enable access plan reuse, rewrite the SQL statement using a parameter marker, as shown in Listing 3.
但是许多打包的应用程序使用具有参数标记的动态sql语句,因此,这些参数标记的值是未知的。
However, many packaged applications use dynamic SQL statements with parameter markers and therefore the values of these parameter markers are not known.
在构造sql语句之后,剩下的步骤就与其他具有参数标记的动态语句完全相同了。
After we compose our SQL statement, all the other steps are the same as for any dynamic statement with parameter markers.
参数化sql语句包含了变量,也称作参数(或参数标记)。
A parameterized SQL statement contains variables, also known as parameters (or parameter markers).
知道出现死锁的应用程序中的sql语句中涉及的参数标记的值可以大大有助于解决这些问题。
Knowing the values of these parameter markers involved in the SQL statement for those applications whose statements are part of the deadlock can greatly help in resolving these issues.
对于占用资源很多的sql语句,查看实际的变量值(字符)而不是参数标记也许对优化器较为有益。
For very expensive SQL statements, the optimizer may benefit from seeing actual variable values (literals) instead of parameter markers.
现在让我们来看一下如何执行在编写应用程序时还不确定并且具有参数标记(即占位符)的SQL语句 ——即真正的动态 SQL 语句。
Now let's see how to execute an SQL statement which is unknown at the time the application is written and has parameter markers or placeholders; that is, a truly dynamic SQL statement.
如果用户极有可能键入非单词或语句的文本,例如登录字段或密码字段,请将这些标记关闭。
Turn them off if there is a strong chance that the user will be typing text that is not a word or sentence, such as a login or password field.
将应用程序变量绑定到预备语句中的参数标记。
Bind application variables to parameter markers used in a prepared statement.
使用参数标记发出sql语句。
可以存在参数标记,因为Design Advisor并没有实际执行sql语句,它仅为它们计算其他可行的访问计划。
Parameter markers are allowed because the Design Advisor does not actually execute the statements, it only evaluates alternative access plans for them.
具有参数标记的sql语句。
由于return语句后面的所有代码都不能执行,因此将其标记为错误。
Since any code after the return statement is unreachable, it's marked in error.
首先,需要构造一个具有5个参数标记的动态sql语句。
First, we will compose a dynamic SQL statement with five parameter markers.
如果一个sql语句满足下面所有条件,则使用参数标记。
Parameter markers should be used if all of the following conditions are true for an SQL statement.
缺省文档定义描述了嵌入在XML内容中的DublinCore标记到Dublin Core语句的映射。
The default document definition describes a mapping between Dublin Core tags embedded in XML content to Dublin Core statements.
要想禁止Web服务器缓存图形,应该在脚本中使用适当的HTMLMETA标记(例如‘no -cache’语句)。
To stop the Web server from caching your graphs, use the appropriate HTML META tags (for example, the 'no-cache' statement) in your scripts.
runtime之后是带有import语句的requires标记。
Following runtime is the requires tag with the import statements.
注释对于通过使用xpath语句添加标记是很有用的。
Annotation is useful for adding markup by using XPath statements.
要了解这类语句的特点,考虑描述web页面的HTMLmeta标记。
To get the flavor of such statements, think of an HTML meta tag that gives the description of a Web page.
标记为NotifyCustomer的invoke语句:这是第二个模拟对象的调用点。
The Invoke statement labelled NotifyCustomer: this is our second mock object invocation point.
换成带有参数标记的语句,一次准备,重复执行,这样做是十分可取的。
With one that has parameter markers and is prepared once and repeatedly executed.
应用推荐