摘要：将多行数据拼接成一行：--wmsys.wm_concatselect wmsys.wm_concat(a.hdid) as test from flow_currentrecord a where a.flowid=222 group by a.flowid;但有大小限制：字符串缓冲区太小，超过varchar 4000长度。扩展：更改返回类型为clob--Type CREATE OR REPLACE TYPE zh_concat_im AUTHID CURRENT_USER AS OBJECT ( CURR_STR clob, STATIC FUNCTION ODCIAGGREGATE... 阅读全文

摘要：1.存储过程使用out参数返回结果存储过程：create or replace procedure PROC_GETSEQ(tbname varchar,ReturnNum out number) is sql_statement varchar2(100);begin sql_statement :='select '||tbname||'_index.nextval from dual'; execute immediate sql_statement into ReturnNum ; end PROC_GETSEQ;EF模型中 添加-函数导入-返回类型集合 阅读全文

摘要：http://www.bootcss.com/ 阅读全文