随笔分类 - ORACLE
摘要:Create Or Replace Function Money2Chinese(Money In Number) Return Varchar2 Is strYuan Varchar2(150); strYuanFen Varchar2(152); numLenYuan Number; numLenYuanFen Number; strRstYuan Varchar2(600); strRstFen Varchar2(200); strRst Varchar2(800); Type typeTabMapping Is Tab...
阅读全文
摘要:ORACLE字符串连接分组串聚函数 wmsys.wm_concatSQL代码:select grp, wmsys.wm_concat(str) from (select 1 grp, 'a1' str from dual union select 1 grp, 'a2' str from dual union select 2 grp, 'b1' str from dual union select 2 grp, 'b2' str fro...
阅读全文
摘要:oracle 动态sql: --差旅费用值变化时 同步更新报销模块的差旅费用值(税率值更新由前台方法实现同步)。 procedure UPDATE_EMAMOUNT(p_tenantid number, p_mainid in number) IS tm_amount decimal(10,2); --差旅费用值 em_formula varchar2(200); --率费计算公式 em_tax decimal(10,4); -- 税费 em_expenseid number; --报销主表Id em_d...
阅读全文
摘要:思路:通过存储过程中游标组织sql,返回处理后的sql实现行转列。oracle 列转行1.新建一个名为TEST表 2.向TEST表中添加数据 INSERT INTO TEST(STUDENT,COURSE,SCORE)select '张三','语文',78 from dual unionselect '张三','数学',87 from dual union select '张三','英语',82 from dual unionselect '张三','物理',90 f
阅读全文