Finally, when you're finished, close the cursor to free up resources.
最后,完成时,关闭游标释放资源。
To view the updated row, you must close the cursor and issue a query to display the new results.
要查看已更新的行,必须关闭该游标并发出一个查询来显示新结果。
In this example, the next step is to close the cursor and execute a SELECT query to display the modified results.
在此示例中,下一步是关闭游标并执行一次SELECT查询以显示修改后的结果。
Unless you require the cursor after the transaction, it is best to close the cursor when the commit operation is carried out.
除非您在事务结束后还需要该游标,否则您最好在执行提交操作后将其关闭。
A holdable cursor, or result, is one that does not automatically close when the transaction that contains the cursor is committed.
一个可保持的游标(或结果),就是说该游标在包含它的事务被提交后,也不会自动地关闭。
Unlike elapsed time, in case of a declare cursor statement the CPU time is the sum of open, all fetched and close.
与消耗时间不同,对于声明游标的语句,CPU时间是打开游标、所有读取操作和关闭游标的时间总和。
This also explains the use of the PREPARE, DECLARE, OPEN and CLOSE SQL cursor statements.
这也解释了使用PREPARE、DECLARE、OPEN和CLOSEsql游标语句的原因。
For a cursor this is the elapsed time between open and close.
对于游标,这就是打开和关闭游标之间所经过的时间。
If the cursor is closed using the close statement before the return of the SQL procedure, the cursor result set will not be returned to the caller or client application.
如果在返回SQL过程之前使用close语句关闭游标,那么游标结果集就不会返回到调用者或客户机应用程序。
This means that subsequent SQL OPEN and CLOSE operations will merely reposition the cursor to the first row of the result set.
这意味着后续SQLOPEN和CLOSE操作只是将游标重新定位到结果集的第一行。
Keep the cursor open for the client application (do not close it).
使游标对客户机应用程序保持打开状态(不要关闭它)。
You can scroll through this window using the cursor keys and close it by typing q or Control-g.
可以使用箭头键滚动这个窗口,按q或Control-g关闭它。
Remember the "cursor position" on close and resume on open.
退出笔记时记住光标位置。打开时恢复该位置。
For example, a CursorLoader provides a Cursor, the consumer of the Cursor should not attempt to close it;
例如,CursorLoader提供了一个游标,游标的使用者不应试图关闭它;
To exit this close-up scene; move the cursor to the end of the screen; pexactly ast the bottom.
要加入此特写面子,搬动光标到屏幕底部以前的底部边缘。
To exit this close-up scene; move the cursor to the end of the screen; pexactly ast the bottom.
要加入此特写面子,搬动光标到屏幕底部以前的底部边缘。
应用推荐