无需修改程序源代码即可使用经过优化的sql语句替换表现不佳的SQL。
Replace poor performing SQL with a more optimal SQL statement without modifying the program source code.
图7展示了如何使用一个更好的语句替换一个从Oracle应用程序捕获的SELECT语句。
Figure 7 shows how a SELECT statement captured from an Oracle application can be replaced with a better one.
需要注意的一个重点是在sql语句中使用以冒号界定的替换操作符。
One important thing to note is the use of the colon delimited replacement operators in the SQL statements.
对于某些替换，需要修改程序逻辑或链接语句。
For some replacements, you may need to change the program logic or linkage statements.
对故事正文应用了许多“搜索并替换”语句；您上面看到的只是一小部分。
There are a lot of search-and-replace statements that apply to the story text; you'll see just a few of them above.
要使用一个等价的基于Linux的模块，您需要用新模块的等价类替换所有导入语句以及所有称为函数和变量的对象。
To use an equivalent Linux-based module, you need to replace all import statements as well as any called functions and variables with the equivalents of the new module.
Perl的tr语句具有不同的语法，它更像sed的搜索和替换表达式。
Perl's tr statement has a slightly different syntax, more like sed's search and replace expressions.
UPDATE语句的set子句用一个新文档替换给定行中的现有文档。
The set clause of the UPDATE statement replaces the existing document in a given row with a new document.
用来在DOM解析器中解析XML并合成insertSQL语句的应用程序代码被替换为以下代码
The application code used for parsing the XML in the DOM parser and composing the insert SQL statement is replaced with the following code
也可以通过包含语句(5)中的整个TREAT(…)表达式(用给定值替换longitude和latitude)来执行显式转换。
Alternatively, you can make the transform explicit by including the whole TREAT (...) expression as in statement (5) (with longitude and latitude replaced by the given values).
如果要改变这个模式，只需修改这个文件开头的SETSCHEMA和SETpath语句，将“ADMIN ”替换为您选择的模式名。
If you want to change this schema, simply modify the SET schema and the SET PATH statements at the beginning of this file to replace "ADMIN" with a schema name of your choice.
可以用以下代码替换多个echo语句，UNIX 只需处理一次执行
you could use the following code to replace the multi-echo statement, and UNIX would only need to process a single execution
在第二个puts语句中(puts代表putstring)，Ruby处理了两次替换。
With the second puts statement (puts stands for put string), Ruby processes two substitutions.
如果试图将GOTO语句与程序名一起使用，那么可以考虑将evaluate语句作为一个替换选项。
If you are tempted to use the GO to statement with a procedure name, consider the EVALUATE statement as an alternative option.
要想进一步增强面向对象特性，可以将if语句的最后一小部分替换为Map，后者将EventType连接到EventHandler工厂对象。
It would be even more object oriented if you replaced the last bits of the if statement with a Map connecting EventTypes to EventHandler factory objects.
如果逻辑上不要求运算符过程调用自身，请移除任何递归调用，或将其替换为不调用自身过程的语句。
If your logic does not require the operator procedure to call itself, then remove any recursive calls or replace them with statements that do not call their own procedure.
转到存储过程编辑器的顶部，并将“CURRENT”从set -schema语句中移除，将模式名称替换为在开始时创？
Go to the top of the stored procedure editor and remove the "CURRENT" from the set-schema statement and replace the schema name with the "ASSOC" schema you created at the beginning.
一般来讲，你可以用条件表达式来替换掉条件语句，无论这些语句的分支是返回语句或者是赋值语句。
In general, you can replace a conditional statement with a conditional expression if both branches contain simple expressions that are either returned or assigned to the same variable.
如果相应语句为某个表达式赋值，请用一个可写的变量、属性或数组元素替换该表达式。
If the statement assigns a value to an expression, replace the expression with a single writable variable, property, or array element.
用你自己的想法替换下划线的语句。
时对象包含址是无法自动转换的声明，该工具将添加迁移错误说明、评论特定语句或替换泛型类型。
When an object contains a statement that SSMA is unable to convert automatically, the tool will add a migration error description, comment on the specific statement or replace it with a generic type.
替换功能会将任何单引号替换使用两个单引号，确保我们稍后构建的sql语句将正常工作。
The replace function will replace any single quotes with two single quotes, ensuring that the SQL statement we construct later will work properly.
替换功能会将任何单引号替换使用两个单引号，确保我们稍后构建的sql语句将正常工作。
The replace function will replace any single quotes with two single quotes, ensuring that the SQL statement we construct later will work properly.
应用推荐