07 2023 档案

摘要:# postgres执行sql片段的定义 语法格式: ```sql DO $$ DECLARE cur record; begin for cur in (select ...) loop ... end loop; end $$; ``` 阅读全文
posted @ 2023-07-28 18:43 站着说话不腰疼 阅读(42) 评论(0) 推荐(0)
摘要:# oracle的open for fetch语法 open for fetch是一种游标循环方式。 ```sql open c1 for '动态sql' [using]; loop fetch c1 into [table] exit when c1%notfound; ... end loop; 阅读全文
posted @ 2023-07-28 11:07 站着说话不腰疼 阅读(735) 评论(0) 推荐(0)