Oracle的汉字转拼音首字母的函数
摘要:CREATE OR REPLACE FUNCTION F_PINYIN(P_NAME IN VARCHAR2) RETURN VARCHAR2 AS V_COMPARE VARCHAR2(100); V_RETURN VARCHAR2(4000); FUNCTION F_NL...
阅读全文
posted @
2014-10-24 08:30
huak
阅读(2423)
推荐(1)
成本卷积报错:CSTPSCEX.explode_sc_cost_flags():40:ORA-01476: 除数为 0
摘要:成本卷积请求:供应链成本累计 - 打印报表运行后报一下错误:MSG-00000: Rollup ID = 236403MSG-00000: Before CSTPSCEX.supply_chain_rollup 2014/10/23 10:35:53MSG-00000: After CSTPSCEX...
阅读全文
posted @
2014-10-23 12:11
huak
阅读(1207)
推荐(0)
使用UTL_SMTP发送中文电子邮件
摘要:就是在原有TOM源码的基础上修改utl_smtp.write_data中,将输出内容进行一下数据转换,这样可以保证中文输出不会出现乱码-----------------------------create or replace procedure html_email( p_to ...
阅读全文
posted @
2014-10-17 08:44
huak
阅读(644)
推荐(0)
利用Oracle数据库的UTL_SMTP发送HTML 邮件
摘要:Ok, that looks hard, but if you use this procedure I wrote, its really quite easy, it does all of the work for you:create or replace procedure html_em...
阅读全文
posted @
2014-10-17 08:39
huak
阅读(395)
推荐(0)