SELECT T.SM_CD , T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002' SELECT T.SM_CD , T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01136' select ID_ SM_CD,NAME_ SM_CFNM from scm_base_info@xgcx where sort_code='3212' select ID_ SM_CD,NAME_ SM_CFNM from scm_base_info@xgcx where sort_code='3209' select ID SM_CD,CONTENT SM_CFNM,'N' CHK1 from chem_memo_pd t where flag = '1' order by id select ID SM_CD,CONTENT SM_CFNM,'N' CHK1 from chem_memo_pd t where flag = '2' order by id select CONTENT LABEL,CONTENT VALUE from chem_memo_pd t where flag = '1' order by id select CONTENT LABEL,CONTENT VALUE from chem_memo_pd t where flag = '2' order by id ? OR T.EXTSHAPE_GRD IS NULL) --查未外观判定的 AND ('True' <> ? OR T.SLAB_INGR_DEC_GRD IS NULL) --查未成分判定的 AND ('True' <> ? OR T.SLAB_TOT_DEC_GRD IS NULL) --查未综合判定的 AND ROWNUM < 1000 ORDER BY T.SLAB_NO ]]> {call ZL_HOST_DCS01.PIB020_SLAB_TOTL(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}