SAP Hana 数据库游标使用方法示例
游标使用示例:将zhangsan用户的创建时间更新成当前时间。
DO
BEGIN
DECLARE CURSOR M_CURR FOR
SELECT ID FROM USER WHERE NAME = 'zhangsan';
DECLARE CUR_TIME TIMESTAMP;
SELECT CURRENT_TIMESTAMP INTO CUR_TIME FROM dummy;
FOR M_CURR_ROW AS M_CURR DO
UPDATE USER SET CREATE_TIME = CUR_TIME
WHERE ID = M_CURR_ROW.ID;
END FOR;
END
post SAP-Garson
原文链接:https://blog.csdn.net/u012586326/article/details/123581938文章来自于网络,如果侵犯了您的权益,请联系站长删除!