蟾蜍的替代品[英] Alternatives to Toad

本文是小编为大家收集整理的关于蟾蜍的替代品的处理/解决方法,可以参考本文帮助大家快速定位并解决问题,中文翻译不准确的可切换到English标签页查看源文。

问题描述

我目前正在使用 toad 用于我在数据库上的日常工作(查询,更新,更新,小脚本,DB对象的浏览等).

我的问题是:由于我的蟾蜍版本是旧的和越野车,它是蟾蜍的(可能但不一定)的替代品?

我们使用的数据库版本是10G和9i.

非常感谢.

推荐答案

尝试了几个月的其他产品后,我又回到了蟾蜍.
我必须承认(恕我直言,以及我对此的使用类型):我没有找到蟾蜍.

.

其他产品中缺少的必不可少的功能是:

  1. 速度.蟾蜍很快.如果您打开2或3个连接,SQL开发人员将开始爬网.当您必须使用时间限制操作时,您真的等不及SQL开发人员打开.

  2. "打开一个新窗口,直到提交"功能(在插入或更新语句后打开一个新窗口,并且您被迫提交或回滚).真的很方便避免悬而未决的提交.

  3. "执行当前语句"功能(Shift-f9). SQL开发人员没有它,或者您被迫选择要执行的查询.

其他推荐答案

oracle sql开发人员>

其他推荐答案

pl/sql开发人员来自 http://www.allroundautomations.nl/.在TOAD和PL/SQL开发人员之间的选择之间提出了大约一半的开发人员更喜欢PL/SQL开发人员.我必须承认PL/SQL开发人员中的代码完成要好得多,但是我仍然更喜欢DBMS管理功能.

本文地址:https://www.itbaoku.cn/post/597410.html

问题描述

I'm currently using Toad for my day-to-day work on our databases (queries, updates, small scripts, browsing of db objects, etc.).

My question is: since my version of Toad is old and buggy, which are the (possibly free, but not necessarily) alternatives to Toad?

The database versions we are using are 10g and 9i.

Thanks a lot.

推荐答案

After trying other products for some months, I'm back to Toad.
And I have to admit that (IMHO, and for the type of use that I'm doing of it): I've found no alternative to Toad.

The indispensable features that are missing in other products are:

  1. Speed. Toad is blazingly fast; SQL Developer starts to crawl if you open more than 2 or 3 connections. When you have to operate with time constraints, you really can't wait SQL Developer to open.

  2. The "open a new window until commit" functionality (a new window is opened after an insert or update statement, and you are forced to commit or rollback). Really handy to avoid pending commits.

  3. The "execute current statement" functionality (shift-F9). SQL Developer doesn't have it, or you are forced to select the query you want to execute.

其他推荐答案

Oracle's SQL Developer.

其他推荐答案

PL/SQL Developer from http://www.allroundautomations.nl/. Presented between a choice between Toad and PL/SQL developer, about half the developers prefer PL/SQL developer. I have to admit the code completion in PL/SQL developer is much better, but I still prefer Toad for the DBMS management functionality.