摘要：
http://download.oracle.com/docs/cd/B19306_01/rac.102/b28759/toc.htm
阅读全文
posted @ 2007-07-15 22:41
东方新秀
阅读(1565)
推荐(0)
编辑
摘要：
select * from abc where trunc(add_months(to_date(InLiBDate,'yyyy-mm-dd'),StorageLife*12))-trunc(sysdate) between -7 and 0
阅读全文
posted @ 2007-07-15 22:25
东方新秀
阅读(145)
推荐(0)
编辑
摘要：
create or replace package PKG_Tools is type ResultData is ref cursor; procedure sp_Page(p_PageSize int, --每页记录数 p_PageNo int, --当前页码,从 1 开始 ...
阅读全文
posted @ 2007-07-15 22:06
东方新秀
阅读(1702)
推荐(1)
编辑
摘要：
select to_date(to_number(to_char(sysdate,'yyyymmdd'))-1,'yyyy-mm-dd') from dual;oracle更新语句:update tablename a set name=(selete name from (select * from tablename where RandomId=0) b where to_number(s...
阅读全文
posted @ 2007-07-15 21:09
东方新秀
阅读(157)
推荐(0)
编辑
