编写Oracle SQL的质量开发环境是什么？ [英] What's a quality development environment for writing Oracle SQL?

问题描述

我正在开发的项目有一个Oracle后端，我们使用 SQL Navigator 5.5用于SQL开发，它真的很糟糕：intellisense不适用于具有多个表的查询，并且您无法同时浏览模式并在屏幕上编写查询。不好玩。

The project I'm working on has an Oracle backend, and we use SQL Navigator 5.5 for SQL development and it really sucks: the intellisense doesn't work for queries with more than one table and you can't browse the schema and write a query on the screen at the same time. Not fun.

我也尝试过使用 Oracle SQL Developer 。这也没有太大的改进 - 查询结果窗口上的图形全部捏造，必须经常通过点击屏幕重新绘制。

I also tried using Oracle SQL Developer. That's not much of an improvement either - the graphics on the query results window get all fudged up and have to be repainted frequently by clicking around the screen.

我正在编写SQL是非常基本的：这里和那里的程序，主要是查询。有人可以推荐一个不错的工具，最好是一个低成本的工具吗？

The extent to which I'm writing SQL is pretty basic: a procedure here and there, mostly queries. Can someone recommend a decent tool, preferably one with a low cost?

推荐答案

所有用于Oracle DB的IDE都或多或少糟糕，TOAD是最好的，但仍然没有像真正的IDE，如Visual Studio或Eclipse。

All IDE:s for Oracle DB are more or less bad, TOAD is the best but still nothing comapared to real IDE like Visual Studio or Eclipse.

TOAD的主要问题是默认的texteditor。查找是噩梦，您无法更改快捷方式，自动对齐也会使用空格，即使您将其配置为使用制表符和其他恼人的功能也是如此。同时取消查询或查询断开连接的会话可能会导致崩溃。 intellisense也有点慢，但它比其他人提供的更好。

Main problem with TOAD is the default texteditor. Find is nightmare and you can't change shortcuts and auto alignment uses spaces even if you configure it to use tabs and other annoying features. Also cancelling queries or making query to disconnected session might crash it. Also the intellisense is kinda slow imo but it works which is better than what others offer.

这篇关于编写Oracle SQL的质量开发环境是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！