Menu
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?
879
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.
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.
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.
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.
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
84
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.
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
