posted on 2005-12-13 12:47 waterye 阅读(3176) 评论(3) 编辑 收藏 所属分类: oracle
老兄,有没有这样的API? 谁有的话发给我好吗? come2u at gmail 谢谢 回复 更多评论
SQL source formatter ant task http://www.it-eye.nl/weblog/2006/01/02/sql-formatter-ant-task/ 回复 更多评论
SELECT MYTABLE.PARENT_COMPANY_ID AS COMPANY_ID, CO2.NAME, CT.COMPANY_TYPE_NAME, CST.COMPANY_SUB_TYPE_NAME, MYTABLE.DOC_COUNT FROM ( SELECT CO.PARENT_COMPANY_ID, COUNT(DISTINCT CN.CONTACT_ID) AS DOC_COUNT FROM TBLCOMPANY CO, TBLCONTACTCOMPANYADDRESS CCA, TBLCONTACT CN WHERE CO.COMPANY_TYPE_ID IN (12,16,20,22,23,25,26,28) AND CO.COMPANY_SUB_TYPE_ID IN (2,3,9,10) AND CO.ACTIVE = '1' AND CCA.COMPANY_ID = CO.COMPANY_ID AND CCA.ACTIVE = '1' AND CN.CONTACT_ID = CCA.CONTACT_ID AND CN.ACTIVE = '1' AND CN.SPECIALITY_ID IN (27, 64, 98, 12, 32) GROUP BY CO.PARENT_COMPANY_ID ) MYTABLE, TBLCOMPANY CO2, TBLCOMPANYTYPE CT, TBLCOMPANYSUBTYPE CST WHERE CO2.COMPANY_ID = MYTABLE.PARENT_COMPANY_ID AND CO2.COMPANY_TYPE_ID = CT.COMPANY_TYPE_ID AND CO2.COMPANY_SUB_TYPE_ID = CST.COMPANY_SUB_TYPE_ID ORDER BY CO2.NAME ASC 回复 更多评论
Powered by: BlogJava Copyright © waterye