摘要:
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... 阅读全文
摘要:
create or replace procedure fenye ( pageSize in number, pageCurrent in number, sumRows out number, pageCount out number, fenye_cursor out sys_r... 阅读全文
摘要:
create table ttt (id number primary key ,name varchar2(20),age number(2))create or replace trigger gger_tt before insert on tttfor each row when (new... 阅读全文