The static SQL statement is pre-compiled and bound to a package before execution.
静态SQL语句是在执行之前预编译并绑定到一个包上的。
For example, suppose the following static SQL statement is found in an embedded-SQL application.
例如,假设在一个嵌入式SQL应用程序中有以下的静态sql语句。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
When the syntax of an SQL statement is fully known at compile time, the statement is referred to as static SQL.
如果在编译时一个SQL语句的语法是完全已知的,那么这个语句就称为静态 SQL。
With static SQL, the preparation steps for executing a SQL statement occur before the application is ever executed, thus offering the opportunity for better performance at runtime.
当使用静态SQL时,执行sql语句的准备步骤是在应用程序执行之前就进行的,因此可在运行时取得更好的性能。
Additional privileges may be required on individual objects being referenced by the stored procedure, depending on the bind options and whether the SQL statement is static or dynamic.
根据绑定选项和sql语句是静态还是动态,存储过程引用到的各对象可能需要更多的特权。
For this article, I will be using a combination of fixed-list dynamic SQL and static embedded SQL (for the UPDATE statement) to create a format-based handler.
对于本文,我将结合使用固定列表动态sql和静态嵌入式SQL(用于update语句)来创建一个基于格式的Handlder程序。
For this article, I will be using a combination of fixed-list dynamic SQL and static embedded SQL (for the UPDATE statement) to create a format-based handler.
对于本文,我将结合使用固定列表动态sql和静态嵌入式SQL(用于update语句)来创建一个基于格式的Handlder程序。
应用推荐