- 博客(1)
- 资源 (1)
- 问答 (1)
- 收藏
- 关注
ORA-01653错误解决办法
----查询表空间使用情况---SELECT UPPER(F.TABLESPACE_NAME) "表空间名",D.TOT_GROOTTE_MB "表空间大小(M)",D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)",TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTT...
2010-06-11 10:45:40 311
linux 学习 初级教程
sSql .append( "select id,hbbh,sfjdm,qfsj,zdjdm," )
.append( " jlsj,zxbq,fjxh,note,")
.append( " to_char(qszxrq,'yyyy-mm-dd') as qszxrq, to_char(zzzxrq,'yyyy-mm-dd') as zzzxrq,qrbz,dw,hkgs,userid,czrq, ")
.append( " case when trunc(sysdate)<qszxrq then '1' ")
.append( " when trunc(sysdate)<=zzzxrq and trunc(sysdate)>=qszxrq then '2' ")
.append( " when trunc(sysdate)> zzzxrq then '3' ")
.append( " else '*' ")
.append( " end as sxbz ,")
.append( " '2' as zxbx ")//默认备选
.append( " from dd_hbxxb a where 1=1 ")
.append( " and not exists (select * ")
.append( " from dd_hbjh b ")
.append( " where a.sfjdm = b.sfjdm ")
.append( " and a.zdjdm = b.zdjdm ")
.append( " and a.id = b.hbid ) ");
2010-03-16
高手进来看看,给点思路
2010-05-19
TA创建的收藏夹 TA关注的收藏夹
TA关注的人