![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
笔记
N0.130
这个作者很懒,什么都没留下…
展开
-
oracle定义游标cursor遍历sql查询结果,通过dbms_output.put_line在output输出
declare cursor x is with v1 as (select * from 表名 where rownum<11) select * from v1;begin for y in x loop dbms_output.put_line (y.字段名); end loop;end;原创 2020-09-27 10:58:09 · 735 阅读 · 0 评论 -
oracle查询出来的字段拼接
oracle查询出来的字段拼接成行: select listagg(t.sub_id , ‘,’ ) within group (order by t.cust_id) from usr_112.BC_SUBSCRIBER t where rownum < 11;原创 2020-09-25 15:49:36 · 1256 阅读 · 0 评论