Oracle - 随笔分类 - 张林春

摘要：SELECT DECODE(TRUNC(-.98),0,REPLACE(TO_CHAR(-.98), '.', '0.'),TO_CHAR(-.98))FROM DUAL;  阅读全文

posted @ 2016-05-26 08:18 张林春阅读(897) 评论(0) 推荐(0)

摘要：create or replace package datapagination is -- Author : 张林春 -- Created : 2008-12-30 14:53:24 -- Purpose : 大数据量分页 -- Public type declarations type M_Cursor is ref cursor; -- Public f... 阅读全文

posted @ 2008-12-30 18:02 张林春阅读(781) 评论(0) 推荐(0)

PL/SQL与测试游标返回结果集

摘要：create or replace package MAnlyse is -- Public type declarations type M_Cursor is ref cursor; -- Public function and procedure declarations procedure anlyse( myCursor out M_Cursor, V_i... 阅读全文

posted @ 2008-12-18 14:47 张林春阅读(912) 评论(0) 推荐(0)

随笔分类 - Oracle