linux 命令集合

Question

select t1.dzzc_id,t1.cpba_id,t1.cplh_id,t1.version_id,t2.cn_name,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate,'YYYY-MM-DD'),t1.ch_num,0)) as abc1,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+1,'YYYY-MM-DD'),t1.ch_num,0)) as abc2,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+2,'YYYY-MM-DD'),t1.ch_num,0)) as abc3,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+3,'YYYY-MM-DD'),t1.ch_num,0)) as abc4,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+4,'YYYY-MM-DD'),t1.ch_num,0)) as abc5,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+5,'YYYY-MM-DD'),t1.ch_num,0)) as abc6,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+6,'YYYY-MM-DD'),t1.ch_num,0)) as abc7,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+7,'YYYY-MM-DD'),t1.ch_num,0)) as abc8,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+8,'YYYY-MM-DD'),t1.ch_num,0)) as abc9,"+
" sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+9,'YYYY-MM-DD'),t1.ch_num,0)) as abc10"+
" from chjh t1,unit t2 where t2.unit_id=t1.unit_id and t1.gwdm_id='"+gwdmId+"' "+
" group by t1.dzzc_id,t1.cpba_id,t1.cplh_id,t1.version_id,t2.cn_name

Answer 1

select t2.ljba_id,t2.lj_name,t2.aqkcl,t2.aqkcl-t2.sysyl,t3.cn_name,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc1,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+1,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc2,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+2,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc3,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+3,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc4,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+4,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc5,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+5,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc6,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+6,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc7,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+7,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc8,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+8,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc9,"+
" nvl(sum(decode(to_char(t1.ch_date,'YYYY-MM-DD'),to_char(sysdate+9,'YYYY-MM-DD'),t1.gwyl,0)),0) as abc10"+
" from gwyl t1,gwkc t2,unit t3 where t1.ljba_id(+)=t2.ljba_id and t3.unit_id=t2.unit_id "+
" and t2.gwdm_id='"+gwdmId+"' and t1.gwdm_id(+)='"+gwdmId+"' "+
" group by t2.ljba_id,lj_name,t2.aqkcl,t2.aqkcl-t2.sysyl,t3.cn_name

Answer 2

select rownum,t1.ljba_id,t1.lj_name,t2.cn_name,t1.unit_price,"+
" t1.aqkcl,t1.aqkcl-t1.sysyl,t1.unit_price*t1.aqkcl,t1.unit_price*(t1.aqkcl-t1.sysyl),"+
" case when (zczrl=0 and gwjkl=0) then 0 when zczrl>gwjkl then 1 else 0 end zclj_flag,fgylj_flag "+
" from gwkc t1,unit t2 where t2.unit_id=t1.unit_id and t1.gwdm_id='"+gwdmId+"'

Answer 3

https://geren.sdb.com.cn/personal/acctquery/perAcctQuery.jsp
http://wssb1.szsi.gov.cn/NetApplyWeb/personacctoutInput.jsp
 connect logis/cplogist @cplogt01;