日期:2014-05-16  浏览次数:20450 次

oralce 查询整理

INSTR

?

SELECT COUNT(INSTR(TO_CHAR(T.FCREATEDATE,'yyyy-MM'),'2013-12')) ?FROM TSERVICEPROJECT T WHERE T.HANDLEMANID='DE59B041E967B07CE04010AC690616BD';