Generating dynamic SQL statement.
生成动态sql语句。
Dynamic SQL execution using JDBC.
使用JDBC的动态sql执行。
Static and dynamic SQL considerations.
静态和动态sql考虑因素。
Your workload mainly consists of dynamic SQL
工作负载主要由动态 SQL 组成
Listing 5 shows part of the dynamic SQL snapshot output.
清单5展示了部分动态sql快照的输出。
Setting re-optimization (REOPT) level for dynamic SQL statements.
为动态sql语句设置重新优化(REOPT)级别。
An SQL descriptor is not required when using fixed-list dynamic SQL.
使用固定列表动态sql时不需要SQL描述符。
Case 5: Having stored procedure using dynamic SQL and external tables.
用例5:采用使用动态sql和外部表的存储过程。
Dynamic SQL statements automatically use these updated statistics.
动态sql语句自动使用这些更新的统计数据。
I normally look at views of elapsed times and CPU times for dynamic SQL.
我平常会查看动态sql的攻击时间和CPU时间视图。
The default NULLID package set is used to execute dynamic SQL statements.
这时使用默认的NULLID包集来执行动态sql语句。
The security model for static SQL is also different than for dynamic SQL.
静态SQL与动态sql的安全模型也不同。
If you can't avoid dynamic SQL code, don't use input directly for columns.
如果无法避免动态SQL代码,请不要对列直接使用输入。
First, we will compose a dynamic SQL statement with five parameter markers.
首先,需要构造一个具有5个参数标记的动态sql语句。
The security model for static SQL is also different from that of dynamic SQL.
静态SQL与动态sql的安全模型也不同。
Dynamic SQL is an ideal candidate for creating generic database handlers.
动态sql是创建通用数据库handler程序的理想选择。
For dynamic SQL statements, authorization takes place on a per statement basis.
对于动态sql语句,授权针对每个语句进行。
Figure 2 shows a comparison between the execution of dynamic SQL and static SQL.
图2显示了动态sql执行与静态SQL执行的对比。
The statement-based handler is better suited for varying-list style dynamic SQL.
基于语句的 Handler程序更适合变动列表样式的动态 SQL。
Package Cache - Memory allocated to store both static and dynamic SQL statements.
包缓存——为存储静态和动态sql语句而分配的内存。
Listing 7 shows the section in the Dynamic SQL snapshot output for this query.
清单7展示了动态sql快照输出中针对该查询的那部分。
This is how Bonita lets you write dynamic SQL queries that are decided at run time.
这就是为什么Bonita允许您编写在运行时声明的动态sql查询。
Tuning dynamic SQL queries was taking more time and effort for the Senate DBA group.
调优动态的SQL查询对于参议院dba团队而言需要花更多的时间和精力。
I may have the same dynamic SQL statement in each interval, if it ran multiple times.
如果一个动态sql语句运行了多次,我可能在每个时间段内拥有相同的动态sql语句。
Additional information on the insert can usually be found in the dynamic SQL snapshot.
通常在动态sql快照中可以找到关于insert的附加信息。
This is in contrast to a dynamic SQL statement, whose syntax is not known until run-time.
反之就是动态sql语句,其语法直到运行时才知道。
So, to form the habit of guarding your database, avoid dynamic SQL code as much as possible.
因此,要形成保护数据库的习惯,请尽可能避免使用动态SQL代码。
The section " Static and Dynamic SQL considerations" covers package concepts in more detail.
“静态和动态SQL考虑因素”一节更详细地讨论包概念。
In the handler application, fixed-list dynamic SQL would be used with the structure based method.
在Handler应用程序中,固定列表动态sql将用于基于结构的方法。
In the handler application, fixed-list dynamic SQL would be used with the structure based method.
在Handler应用程序中,固定列表动态sql将用于基于结构的方法。
应用推荐