select tybm_id as tybm,decode(HZHBM_ID ,0,'zcls','否','SHFJC') as jmbh
from t_fhdjh
where tybm_id=p_tybm
and substr(to_char(hzbm_id),1,2)=p_zrcbm
and HZHBM_ID not in (select jmbh from t_gncz where tybm_id=p_tybm
and substr(jmbh,1,2)=p_zrcbm
and nf=p_nf);
from t_fhdjh
where tybm_id=p_tybm
and substr(to_char(hzbm_id),1,2)=p_zrcbm
and HZHBM_ID not in (select jmbh from t_gncz where tybm_id=p_tybm
and substr(jmbh,1,2)=p_zrcbm
and nf=p_nf);
解决方案 »
- orcl11g
- PowerCenter 客户端有没web service 组件,求指点
- 哪位仁兄, 能吐血贡献oracle develop 9i
- linux系统中IMP问题
- 大虾们帮忙瞧瞧:在vb中怎样找到oracle的数据库名啊?
- alter Database SET TIME_ZONE = '+08:00' 报错?
- alter table BFJXC.SPXX_JB add constraint uk_spgg_test unique(SPGG)提示:
- 各位oracle高手,小弟在作jsp的在solaris 8 下使用resin,如何像使用odbc那样选择
- oracle中export数据?sys用户和system用户的区别?
- oralce11g占用内存太大了吧
- oracle字段不能自增的问题
- oracle监听的问题,请高手进来看看。
select tybm_id as tybm,HZHBM_ID as jmbh,0 as zcls,'否' as SHFJC
from t_fhdjh
where tybm_id=p_tybm and substr(to_char(hzbm_id),1,2)=p_zrcbm
and HZHBM_ID not in(select jmbh from t_gncz where tybm_id=p_tybm
and substr(jmbh,1,2)=p_zrcbm
and nf=p_nf) ;
and substr(jmbh,1,2)=p_zrcbm
and nf=p_nf) as jmbh and substr(to_char(hzbm_id),1,2)=p_zrcbm;