摘要： 在表中循环插入日期--创建会话级临时表create global temporary table rq(id number primary key ,sj varchar2(20))on commit preserve rowsselect * from rq--循环插入日期declare c_i ... 阅读全文

摘要： create or replace procedure pro_tableesists (v_table in varchar2) isv_num number;begin select count(*) into v_num from user_objects where object_name... 阅读全文

摘要： listagg( ) within group ( order by ) 与 wm_concat--oracle 11g 及以后适合 最好select spbywslid,listagg(xm,',') within group (order by spbywslid) col_name fr... 阅读全文