oracle 数据字典

select ID,BH,e.dictmean as BM,SPBM,d.dictmean 
as MZ,DZMZ,YE,SITES,SITE_LY,SITE_HS,to_char(FQRQ,'yyyy-mm-dd') as FQRQ,to_char(HSRQ,'yyyy-mm-dd') as HSRQ,f.dictmean as FLAG 
from INTO_COUPONS c ,
sys_dict2 d,
sys_dict2 e,
sys_dict2 f where 
(c.mz = d.dictno and d.mainno = 3042) 
and (c.bm = e.dictno and e.mainno = 3046)
and (c.bm = f.dictno and f.mainno = 3047)