SQL Developer Reviews & Product Details

You can add as many connections you want, creating a table or updating any table structure - variable type, size etc is just so easy with Oracle sql developer by just right click and edit.. / create table.. A Connection added is so well structured with tables, views, triggers,sequences, views, procedures, functions, etc Review collected by and hosted on G2.com.

The timeout span must be increased.. and there's no shortcut to switch between two connections. Also the export time is too large for a small file too.. Review collected by and hosted on G2.com.

We can save multiple session of different schema. We can view all table and user in the schema in a single window, can place request to view DDL which is generated automatically. Multiple queries can be made in a single window. Review collected by and hosted on G2.com.

The SQL developer does not prompts with correct syntax if something is missed. If a query is killed it take lot of time to execute it. Unable to export data in the latest excel also very less format options are available to export. Review collected by and hosted on G2.com.

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Review collected by and hosted on G2.com.

Never know when a query has been truly terminated. Even if one has access to the SQL Monitoring or Monitoring SQL Sessions, it still may show as being terminated but in actuality, within OEM, the query could still be running and need to be killed there. The inability to truly know when a session has ended results in frustration because the next query may not be able to run because the last is actually still running.

The tuning advisor runs very long and is not always helpful.

Not knowing the status of a query can be frustrating. That is, if a query is running long, it may show as "running" (i.e. the horizontal bar moving back and forth at the bottom of the screen), but in actuality, it may be hung up. Review collected by and hosted on G2.com.

I enjoy sql developer for what it is. It's quick, easy to use, the layout makes sense, and it's not a super resource hungry. Switching between connections is quick and it offers a fair amount of functionality tailored towards DBAs. Review collected by and hosted on G2.com.

There isn't much to dislike really. One thing I would like them to add would be themes. Personally I enjoy the dark theme option from Microsoft products, I wish Oracle would adopt that. It's definitely not crucial functionality or anything, but a nice feature when all your other apps are dark and you're working at night. Review collected by and hosted on G2.com.

SQL Developer is a great tool to assist with tuning and testing SQL, as well as looking at explain plans and generating better outputs (xls, csv, etc.) Review collected by and hosted on G2.com.

Not all of the features are easy to find/use. There are a number of features that I found simply from clicking around and by luck. Not sure if there is a good documentation page out there. Review collected by and hosted on G2.com.

I started working with oracle databases just this year. I would like to say that working with SQL developer it'ts been a good experience from all perspective. You have all the tools you need in place from data monitoring to export-import data from multiple sources. I'm mainly working as an ETL engineer so most of the time I write long queries inside sql developer. I like the way how we can debug our code and get insight directly from the IDE. There are a lot of functionality out of the box if you are a DBA you can monitor the queries in real time and check the performance of the databases. I work mostly with CSV files and it's very easy to export those kind of files to a table in any oracle database. Current version is 12c and is getting a lot of features with current updates. Review collected by and hosted on G2.com.

The interface is kind of old from my perspective. There are plenty of tools than can connect to oracle but SQL developer still have more advantages over the others and that is why I still using Oracle SQL Developer most of the time. Review collected by and hosted on G2.com.

Sqldeveloper is a great software for Oracle db. It Is Easy to install and to use, very stable, and has a clean graphic interface. I have ever used sql developer as client for Oracle Databases. Review collected by and hosted on G2.com.

I had some problems using last version with console log in SQL procedure and I had ti install 4.2 version Review collected by and hosted on G2.com.

Organized user interface. Easy to hands on. It gives the suggestions when we typing the query it helps to speed up your job done. Also process the queries very fast. Review collected by and hosted on G2.com.

Actually every software has some disadvantages like as sometimes loading the databases may take long time. But it happens very rarely. Review collected by and hosted on G2.com.

It's really easy to duplicate connection details; we have a lot of databases that follow similar patterns, and the ability to open one you already know is correct, change the details slightly and re-save is very convenient and means I don't spend a lot of time trying to find some small typo. Review collected by and hosted on G2.com.

The user interface isn't very intuitive, and I often have to hover over buttons to figure out what they're supposed to do. I tend to stick to only a few of them because I don't always know what kind of side-effects will take place if I click the wrong thing. It also uses more RAM and CPU than I would expect since most of the heavy lifting should be taking place in the database itself. Review collected by and hosted on G2.com.

This is one of the most helpful and easiest data tool available. the connections have been pretty fast and I never has issues with any sql queries ever, unless they are wrong, lol. I would recommend this to any Review collected by and hosted on G2.com.

Sometimes, it doesnt tell you why some queries does not work, promoting me to run it the second time to get to result. Review collected by and hosted on G2.com.