创建UpdateBook更新语句。
图3显示了这个更新语句。
可以在单一更新语句中对同一文档做多处修改。
You can certainly make multiple modifications to the same document in a single update statement.
图10显示一个更新语句正在操作一个包含私有数据的列。
Figure 10 shows that an update statement is manipulating a column that contains private data.
如果将位置更新语句移动到不同的包,则需要进行相应的配置。
If you move the position update statement to a different package it is necessary to perform a configure.
从清单5显示的查询结果可以看出,针对失败的更新语句有一条审计记录。
From the query results, shown in Listing 5, you can see that one audit record was generated for the failed update statement.
来自HTTP请求的客户个人数据作为参数传递给更新语句;不需要修改。
The customer profile data from the HTTP request is passed as a parameter to the update statement; no modifications are needed.
初级的方法是使用一个游标对表进行扫描,并为每一行执行一个定位的更新语句。
The naive approach USES a cursor to scan the table and execute a positioned update statement for each row.
在清单8中显示的查询结果中,您可以看到有一条关于失败的更新语句的审计记录。
From the query results, shown in Listing 8, you can see that one audit record was generated for the failed update statement.
在翕清单8中显示的查询结果中,您可以看到有一条关于失败的更新语句的审计记录。
From the query results, shown in Listing 8, you can see that one audit record was generated for the failed update statement.
在更新9中已经看到,在一个更新语句的modify子句中可以包含对同一文档的多个更新操作。
You have seen in update 9 that you can include multiple update operations for the same document in the MODIFY clause of a single update statement.
发送到缓冲表的远程数据源的更新语句数。默认值为1。调整该值可大大提高更新性能。
The number of update statements sent to the remote data source for buffered tables. 1 is the default. Adjusting this value can greatly increase update performance.
把对象转换为xml格式之后,可以通过执行常规的SQL更新语句更新employee表中的记录。
After you have the object in XML format, you can issue a regular SQL update statement to update the record in the table EMPLOYEE.
这使得数据库系统管理员可以优化没有使用更新语句处的性能,或使用更新语句时也可以防止死锁。
This allows the database administrator to optimize the performance where the update syntax is not used, or to prevent deadlocks when it is used.
在value域中,输入一个主机变量:ISBN。这一步创建一条更新语句,该语句将更新一本特定书籍的属性。
In the Value field, enter a host variable: ISBN This creates the update statement that will update the attributes in a particular book.
在SQL更新语句中使用转换表达式时,很少在COPY子句中使用筛选谓词,通常是在 SQLWHERE 子句中进行筛选。
When you use transform expressions in SQL update statements, you rarely have a filtering predicate in the COPY clause but rather in the SQL WHERE clause.
在SQL更新语句中使用转换表达式时,很少在COPY子句中使用筛选谓词,通常是在 SQLWHERE 子句中进行筛选。
When you use transform expressions in SQL update statements, you rarely have a filtering predicate in the COPY clause but rather in the SQL WHERE clause.
应用推荐