Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
N/A
Pricing
Oracle SQL Developer
Editions & Modules
No answers on this topic
Offerings
Pricing Offerings
SQL Developer
Free Trial
No
Free/Freemium Version
Yes
Premium Consulting/Integration Services
No
Entry-level Setup Fee
No setup fee
Additional Details
—
More Pricing Information
Community Pulse
Oracle SQL Developer
Considered Both Products
SQL Developer
Verified User
Professional
Chose Oracle SQL Developer
They do almost the same things, but I particularly I prefer TOAD, maybe because when I started programming with Oracle Database it was the first tool that I used and I think it's easier to use too.
SQL Developer can be considered a light-weight version of Toad Data Point. It is missing the database federation capability but allows for more native integration with Oracle databases.
Oracle SQL Developer has rich User interface and user friendly compared to other databases, it is also used In large applications which has huge data sets and need good performance that is only possible in Oracle Developer, It also gives us fast curd operations and better space …
Having used both TOAD and PL/SQL Developer, I believe SQL Developer from Oracle is a most than acceptable alternative, maybe not as powerful and complete as them but being free has a very positive impact. Most development profiles can work perfectly using SQL Developer while …
Oracle SQL Developer is available on multiple platforms, Windows Mac Linux and it's free. SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage …
[The] developer's user interface is very handy and simple to use. [W]e can see full query [executions] and optimize the query data import and export, [which] is very easy. [Easy] [installation] and setup [of the] debugging [process] is easy.
[Oracle SQL Developer] is well suited when one doesn't need to work heavily on DB; a person who has just started learning SQL or working on SQL can work easily using SQL developer. It's free.
In addition to Oracle SQL Developer I have used Microsoft SQL Server management studio, Toad for Oracle, SAS, and other third party SQL tools. I have found Oracle SQL Developer to be one of the best all around tools for accessing Oracle databases, as well as interfacing with …
Oracle SQL Developer is better than SQL server, as it is easy to set up and install. Oracle SQL Developer is better in UI than SQL server. The features are almost the same. In comparison to DBeaver, it is much easier to set up as DBeaver's installation and setup is very …
Oracle SQL Developer is neck and neck with other tools. It offers all the required features and is much more reliable than many other vendors. Since it’s developed by Oracle, it works well with Oracle. It’s ultimately down to individual selection but Oracle SQL Developer offers …
IDEA has a built-in database connection and query platform. It has a slightly better code completion feature but lacks many of the functions of the SQL developer.
This SQL Developer product stacks up well against TOAD, in that it has most of the functionality that TOAD has and allows better organization for me. It also allows me to make connections within new folders of the same database with different users. The best thing about SQL …
Oracle SQL Developer, in comparison to Toad for Oracle, works very similarly. Toad for Oracle is very useful for complex data management, and this includes monitoring queries and managing permissions. Oracle SQL Developer is great as a simple tool for developers. It has …
SQL Developer is a very simple tool that is user-friendly and easy to understand for beginners as well. As SQL Developer is Oracle's own product, the Oracle product support is better when it is mentioned about the use of SQL Developer in Service Requests. The area of …
DBArtisan is the elephant in the room for a number of reasons. It not only does everything SQL Developer does, but it also has a huge number of management functions built-in. However, it is immensely expensive and, for your average developer, way overkill. Squirrel is also a …
Oracle SQL Developer has a much simpler, novice-friendly interface than TOAD or Sequel Pro. Less clutter and fewer buttons makes it easier for a non-expert/non-DBA to navigate and query. Having a product supported by Oracle itself is also a draw. If an issue is being …
Prior to using Oracle SQL Developer, I used Toad Data Point. I did not have any decision making in choosing Oracle SQL over Toad Data Point but I can say the ease of use is noticeable in Oracles SQL. Oracle is every bit as good if not better than Toad Data Point due to ease …
Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.
It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.
Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
Inability to run multiple queries on the same database. You can only run one query on a given database.
Analytical models created from complex tables isn't accurate, and needs work.
Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.
At times, Oracle SQL Developer may experience freezing issues. However, despite this occasional inconvenience, the tool offers valuable features such as the ability to integrate plugins like utPLSQL, which greatly assists in debugging and testing our packages. Additionally, the usage of breakpoints and the flexibility to format text according to individual configurations enhance the debugging process.
I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.