.Net  

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(substr(a.path,4,1))=b.id) where a.RandomId=1

posted on 2007-07-15 21:09  东方新秀  阅读(155)  评论(0编辑  收藏  举报