waterye

Online Format SQL

在线格式化SQL

http://www.sqlinform.com/

http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl

From:  http://awads.net/wp/2005/12/12/format-your-sql-the-easy-way/

posted on 2005-12-13 12:47 waterye 阅读(3167) 评论(3)  编辑  收藏 所属分类: oracle

Feedback

# re: Online Format SQL 2006-01-24 16:58 大嘴巴

老兄,有没有这样的API?
谁有的话发给我好吗? come2u at gmail
谢谢  回复  更多评论   

# re: Online Format SQL 2006-01-24 17:09 Water Ye

SQL source formatter ant task

http://www.it-eye.nl/weblog/2006/01/02/sql-formatter-ant-task/  回复  更多评论   

# re: Online Format SQL 2007-04-05 18:20 asdasd

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  回复  更多评论   


只有注册用户登录后才能发表评论。


网站导航: