Eclipse Galileo SQL Editor:是否有代码格式化(tidy)功能?

时间:2023-01-14 18:39:10

I do like the SQL editor now bundled with Eclipse but I can't seem to find a way for it to format my code like eclipse will with my java.

我喜欢现在与Eclipse捆绑在一起的SQL编辑器,但我似乎找不到像我的java那样用eclipse格式化代码的方法。

Did I miss something, or does anybody have any alternatives?

我错过了什么,或者有没有其他选择?

Thanks

====EDIT====

I'd also be happy if there was an alternate plug-in that someone could recommend.

如果有人可以推荐的备用插件,我也会很高兴。

1 个解决方案

#1


4  

This had bothered me in the past, but I shelved it until I saw your question. The DBViewer plug-in seems to do a fairly decent job of this, but I only tested it with basic SQL. For example, it will transform

这在过去困扰了我,但在我看到你的问题之前我搁置了它。 DBViewer插件似乎做得相当不错,但我只用基本的SQL测试过它。例如,它将转变

select * from urbase order by foo;

into

SELECT
        *
    FROM
        urbase
    ORDER BY
        foo

This does the best job out of any that I tested, although there might be better plug-ins out there.

这是我测试过的最好的工作,尽管可能有更好的插件。

#1


4  

This had bothered me in the past, but I shelved it until I saw your question. The DBViewer plug-in seems to do a fairly decent job of this, but I only tested it with basic SQL. For example, it will transform

这在过去困扰了我,但在我看到你的问题之前我搁置了它。 DBViewer插件似乎做得相当不错,但我只用基本的SQL测试过它。例如,它将转变

select * from urbase order by foo;

into

SELECT
        *
    FROM
        urbase
    ORDER BY
        foo

This does the best job out of any that I tested, although there might be better plug-ins out there.

这是我测试过的最好的工作,尽管可能有更好的插件。