Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Is there a better tool compared to Oracle SQL Developer? [closed]

Tags:

editor

oracle

ide

oracle-sqldeveloper

plsql

I'm just starting to learn Oracle SQL Developer as I develop PL/SQL code at my new job, and while it's an okay tool, it lacks a lot of the conveniences and features that you'd want when writing programs using a different IDE (such as IDEA).

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?

like image 879
egervari Avatar asked May 01 '12 02:05

egervari

People also ask

Does SQL Developer have future?

The future of SQL is really bright and most of the successful SQL professionals ensure that they know each and everything about current trends of the database and stay updated about the technical market.

What is the difference between Oracle Developer SQL Developer and PL SQL Developer?

SQL is a Structural Query Language created to manipulate relational databases. It is a declarative, detail-oriented language. Whereas, PL/SQL is a Procedural Language/Structured Query Language that uses SQL as its database. It is an application-oriented language.

Is Oracle SQL outdated?

The answer is that PL/SQL is not growing, but not going away either. Because it is used in the Oracle database, and the Oracle database is a fixture of enterprise systems world-wide, it will outlive you. High-performance batch processing has to happen close to the data, so PL/SQL will continue to rule in this area.

Which database is better SQL or Oracle?

Compared to other Databases, Oracle is very scalable, portable, and easily programmable. Any person who has some basic knowledge of SQL can execute queries easily. It also enables easy transfer of data between different Databases. Since 1980, many companies have used Oracle.

2 Answers

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

like image 84
Maddy Avatar answered Nov 16 '22 00:11

Maddy

I think Oracle SQL Developer is okay to develop PL/SQL code, It is a free software produced by Oracle org, it might lack of some specific features. but it satisfies most of common usages and functionality.

Toad is a more powerful tool with very widely used. but you need get a license.

like image 36
C.c Avatar answered Nov 16 '22 00:11

C.c
Sign in to Comment

Related questions

How to grant execute on dbms_lock in Oracle?
Workaround for ORA-00997: illegal use of LONG datatype
GATHER_PLAN_STATISTICS does does not generate basic plan statistics
Does Visual Studio Server Explorer support custom database providers?
How can I change the SID of an Oracle XE instance
Non-negligible execution plan difference with Oracle when using jdbc Timestamp or Date
How to get input from user at runtime
Hibernate warning about follow-on locking using Oracle 10g
Retrieve Oracle last inserted IDENTITY
Exporting a CLOB to a text file using Oracle SQL Developer
How to automatically generate identity for an Oracle database through Entity framework?
When implementing a statement-level trigger on a table, is it possible to obtain the OLD and NEW records for all affected rows?
Mutating Table in Oracle 11 caused by a function
Why do I get #### in the NUMBER column after format?
Space is not allowed after parameter prefix ':'
How to write pandas dataframe to oracle database using to_sql?
BDE vs ADO in Delphi
Oracle equaivalent of java System.currentTimeMillis()?
How can I see queries that are executed against Oracle?
Which is better: single global sequence vs. sequence per table?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!