文章分类 -  oracle 存储过程示例

oracle 数字进制转换
摘要：、from http://www.eygle.com/archives/2004/06/oracle_howto_convert.html 阅读全文
posted @ 2011-07-18 13:48 jianggc.zj 阅读(150) 评论(0) 推荐(0)
oracle 汉字处理
摘要：from ： http://www.itpub.net/viewthread.php?tid=847680&extra=page%3D1%26amp%3Bfilter%3Ddigestfrom : http://www.itpub.net/876643,4.html 阅读全文
posted @ 2011-07-18 10:39 jianggc.zj 阅读(223) 评论(0) 推荐(0)
实现 split 函数
摘要：CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000);CREATE OR REPLACE FUNCTION fn_split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN ty_str_splitIS j INT := 0; i INT := 1; len INT := 0; len1 INT := 0; str VARCHAR2 (4000); str_split ty_str_split := ty_str_split ();BEGIN len := LENG 阅读全文
posted @ 2011-05-23 17:25 jianggc.zj 阅读(196) 评论(0) 推荐(0)