#Sqlpro studio for sqlplus drivers#
#Sqlpro studio for sqlplus code#

The result rows have alternating colours, making it easy to read. When writing and running a query, itвЂ™s easy to see the results of the query. It has large toolbar buttons and uses a ribbon concept, which I think is the best way IвЂ™ve seen of organising many functions. After connecting, the first thing I noticed was the clean UI. ItвЂ™s easy to create a connection in PL/SQL Developer. In my opinion, itвЂ™s a great tool and will really help you work with SQL. ItвЂ™s often mentioned as being вЂњalmost as goodвЂќ as Toad. ItвЂ™s often mentioned in reviews and questions about Oracle IDEs as being a good choice if youвЂ™re willing to pay the money for the license. I havenвЂ™t used it a lot since, but itвЂ™s among the three most recommended IDEs when browsing the Internet (along with Toad and SQL Developer).

I was very impressed with it back in 2007. I came from university where we used SQL Developer (version 1) and moving into PL/SQL Developer at the time was a big move. PL/SQL Developer was the first IDE that I used when I started my career. So, if youвЂ™re a vendor of one of these tools, and IвЂ™ve gotten something wrong, please let me know via the comments or the contact page. Some features may actually exist where IвЂ™ve said they donвЂ™t, or I might have done something wrong that causes the error. Some were good, and some not so good.ДЄlso, I didnвЂ™t spend a great deal of time with each IDE as that would take too long. The user interfaces were quite different between them.

#Sqlpro studio for sqlplus code#

Many other standard features were implemented in a similar way, such as code complete or exporting data. Many features seem standard and were implemented in different ways, such as explain plans. The easier a tool is to create a connection, the better.

#Sqlpro studio for sqlplus drivers#

Others involved setting up a System DSN on your computer and connecting via that, and others involved installing other drivers and tools just to connect. Some were simple and just involved entering a database, service name, username, and password. This excludes tools like SQL*Plus and SQLcl.Д«efore we get into my recommendations and more details about each IDE, there were a few things I noticed when testing and analysing these SQL editors.ДЇirst, the connection process was different for many of them. It also excludes data modelling tools and data visualisation tools. While Notepad++ is a great tool and has SQL syntax highlighting, it doesnвЂ™t let you run SQL queries. This excludes text editors such as Notepad++.

Must be able to write and run SQL queries.

This guide has been created and was last updated in 2020. Some sites had a comparison of IDEs but they were out of date. IвЂ™ve seen many questions on websites such as Quora and Stack Overflow about вЂњwhich IDE is the bestвЂќ and вЂњwhich SQL Editor should I useвЂќ, and while there were some good answers, there wasnвЂ™t really a single place to compare all of the options. ItвЂ™s a list of all SQL editors available for major databases: Oracle, SQL Server, MySQL, PostgreSQL, SQLite, and MariaDB. This guide is a comparison of all SQL IDEs currently available. Are you looking for an SQL IDE (Integrated Development Environment) or SQL editor? Take a look at this list of all of the IDEs currently available.