English 中文(简体)
是否有更好的工具与Oracleker开发商相比? [闭门]
原标题:Is there a better tool compared to Oracle SQL Developer? [closed]

我们不准许向软件图书馆、辅导、工具、书籍或其他场外资源征求建议的问题。 你可以ed问这个问题,以便用事实和引证来回答。

Closed 8 years ago.

我刚刚开始学习Oracleker的研发商,当时我在新的工作中制定了PL/SQL的法典,虽然它是一个oka工具,但它却缺乏你在利用不同的国际民主和选举援助学会(如民主选举学会)编写方案时所希望的许多便利和特点。

Is there a different tool out there that really assists when building large packages/procedures/functions of PL/SQL code compared to Oracle s SQL developer 3? It would be great to get features like code completion, or to have the ability to CTRL-click a procedure name to quickly jump to a piece of code, and other nice features of this type?

最佳回答

PL/SQL Developer by AllroundAutomations its really good one. Provides all the basic features that other tools provides. And very good while debugging your stored procedures, functions and triggers. But it is also a licensed version. There are no. of add-ons are available which makes tool more powerful and You can customize your Plsql developer as shown in following links. here and here

问题回答

我认为,Oraclealker的研制是制定PL/SQL代码的征兆,这是由Oracle org制作的免费软件,可能缺乏某些具体特征。 但它满足了大多数共同使用和功能。

Toad是一个更强大的工具,广泛使用。 但需要获得许可证。

PL/SQL developer was interesting to try out a couple years ago, but I m always finding myself doing a decent amount of DBA type work, and it wasn t very helpful with that. My DBA skills are not particularly strong, so that area, Toad and SQL Developer definitely come out ahead.

总而言之,我更喜欢Toad(尽管这可以成为一种资源 h,并且使你希望的一切努力成为一种痛苦)。 不同的版本(专门针对开发商的版本)可能适合你们。

I recently started a new job, and decided to give SQL Developer a run (this is primarily because Toad is expensive enough that some places won t spend the money on it...like my last job...so it seemed like a good idea to pick a tool I knew I d have everywhere). It certainly has its issues (it seems to be rather stubborn about breaking a connection if a query is running...but its possible thats a java thing), but it is free, lightweight, and gets the job done.

致: 此时此刻(对于可预见的未来而言),严格来说是32倍。 它搭建在64个轨道窗口箱上,连接64个轨道的Oracle数据库,但Oracle客户必须是32个轨道。





相关问题
Export tables from SQL Server to be imported to Oracle 10g

I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

How to make a one to one left outer join?

I was wondering, is there a way to make a kind of one to one left outer join: I need a join that matches say table A with table B, for each record on table A it must search for its pair on table B, ...

Insert if not exists Oracle

I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like: INSERT ALL ...

How can I store NULLs in NOT NULL field?

I just came across NULL values in NOT-NULL fields in our test database. How could they get there? I know that NOT-NULL constraints can be altered with NOVALIDATE clause, but that would change table s ...

Type reference scope

I m studying databases and am currently working on a object-relational DB project and I ve encountered a small problem with the number of possible constraints in an object table. I m using "Database ...

OracleParameter and DBNull.Value

we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...

热门标签