SQLExecute()函数执行语句
执行语句。
ROWS_READ: 在执行语句期间,所读取的总行数。
ROWS_READ: Total number of rows read during the execution of the statement.
一旦备份完成,系统将让所有被阻塞的语句完成它们的执行。
Once the backup is complete, the system will let all blocked statements complete their execution.
最后,执行该语句,检查错误,并关闭连接。
Finally, execute the statement, check for errors, and close the connection.
一个回调函数,在语句成功执行时调用。
A callback function invoked if the statement is executed successfully.
执行同一条sql语句。
接下来,执行清单6中的语句创建表。
Next, execute the statement in Listing 6 to create the table.
好的访问计划对于sql语句的快速执行至关重要。
A good access plan is key for the fast execution of an SQL statement.
否则,将不执行触发器语句的操作部分。
Otherwise the action part of the trigger statement does not get executed.
该语句在过程虚拟机(PVM)中执行。
The statement was executed within the procedure virtual machine (PVM).
现在再次执行该语句。
如果您想要测试sql语句,按F5执行该脚本。
If you want to test the SQL statement, press F5 to execute the script.
过程不会自动执行commit语句。
loop语句不限次数地执行一个语句块。
The LOOP statement executes a statement block for an unspecified number of iterations.
将多个sql语句串在一起并在一个批处理中执行它们的功能。
The ability to string multiple SQL statements together and to execute them in a batch.
准备和提交用于执行的语句。
比如可以在CLPPlus 中无缝地执行创建和删除包、过程、函数、触发器等的语句。
Statements like create and drop package, procedure, function, trigger, etc. can be executed seamlessly in CLPPlus.
但是,如果执行了UPDATESTATISTICS语句,那么效率就会高得多。
Had you executed the UPDATE STATISTICS statement, it would have been much more efficient.
而执行发货的真正语句却十分简单。
The actual statement to execute the delivery is rather trivial.
for 循环,它对一个语句块执行一定次数。
The for loop, which executes a block of statements a certain number of times
要想查看每次执行此sql语句的详细信息,单击Drill down。
To view the details of each execution of the SQL statement, click on Drill down.
TOTAL_SORT:该语句所执行的排序总数目。
TOTAL_SORT: Total number of sorts executed by the statement.
对于给定的if - then - else语句,if部分就是被执行的路径。
At a given if-then-else statement, the if part is the path that was executed.
OPENcursor语句作为FETCH过程的一部分执行。
The OPEN CURSOR statement is executed as part of the FETCH process.
ID:执行的sql语句的ID。
TotalTime:执行此语句的总时间(以秒为单位)
由于return语句后面的所有代码都不能执行,因此将其标记为错误。
Since any code after the return statement is unreachable, it's marked in error.
以Oracle为例,假设执行以下SQL语句
Using Oracle as an example, assume the following SQL statement
因此,在第一次编译sql语句之后,后来的调用只要继续执行相同的执行计划即可。
Subsequent invocations will simply keep executing the same execution plan. Let's use an example.
应用推荐