select--商品番号的前4位substr(ITEM_CD ,1,4),--商品名称ITEM_NAMEfrom RCV_ISSEC_CDwhere --在库数量不为空(ICV_NUM is not null or (--库数量不是空CV_NUMis not null and--入库数量等于出库数量或者入库数量等于100(RV_NUM = CV_NUM or RV_NUM = 100) )and--商品名长度大于4length(ITEM_NAME)>4;说明:【--】是注释的意思,直接copy到oracle中就可以,不会报错。---以上,希望对你有所帮助。...
select a.ITEM_NAME(select ITEM_NAME from RCV_ISSEC_CD where (ICV_NUMis not null or CV_NUMis not null) and (RV_NUM=100 or CV_NUM =100) and length(ITEM_NAME)>4 order by ITE...