TrustRadius Insights for Oracle SQL Developer are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Seamless Integration: Users have consistently praised the seamless integration of Oracle SQL Developer with all versions of Oracle databases, eliminating the need for complex setup processes. This feature has been highlighted as a major advantage, enhancing user experience and workflow efficiency.
Easy Set-up and Installation: Reviewers appreciate the straightforward set-up and installation process of Oracle SQL Developer, along with its exceptional cross-OS compatibility. The ease of getting started with the tool has been positively acknowledged by users, making it accessible across different operating systems.
User-Friendly Interface: The simple user interface and effective functions contribute to the overall user-friendliness of Oracle SQL Developer, as expressed by users in their reviews. The intuitive design and smooth navigation enhance usability, allowing users to easily access and utilize various features within the application.
We are using Oracle in integration with TIBCO AMX BPM to store data for managing users, update KYC details, store daily operations data etc. Oracle SQL Developer provides a solid graphical user interface to view and update data. It is easy to segregate data using schema names in Oracle SQL Developer. Both developers and administrators are using Oracle SQL Developer as it is easy to learn and use. We have created tables, views, stored procedures and indexes using Oracle SQL Developer.
Pros
Easy to create stored procedure
Easy data management using GUI
IntelliSense for guiding query building
Support for multiple schemas within single connection
Cons
Might not be suitable for Production environment
Scaling is limited
Can be difficult to operate for beginners
Likelihood to Recommend
Oracle SQL Developer helps obtain performance metrics by showing the time taken to run any query or stored procedure. It allows to create indexes on tables for fetching results much faster. We can create sequence which can be configured for auto increase and is useful for numbering the records stored in the tables. Before connecting to any server there is an option to test the credentials which allows verification of credentials without blocking the connection when user is not too sure about the password. It provides support for queues, XML schemas as well
VU
Verified User
Employee in Information Technology (5001-10,000 employees)
I use Oracle SQL Developer as an editor to run various queries and export data to my desired format as Excel or CSV files. I usually use it on Windows, but it could be used on other operating systems, so it is a great advantage for me when I change platforms.
Pros
Export Data
Run SQL statements
Browse Database Objects
Cons
Search for a specific object in the database
Debug
Likelihood to Recommend
Scenario where Oracle SQL Developer is well suited could be to browse, create, edit and drop database objects; execute SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; and view and create reports. I never encounter some situations for what I need where Oracle SQL Developer is not.
Oracle SQL Developer is used to solve production issues for our client. It is used across the whole organization by different support and development teams. The business problems that it solves is production issue that occur when the business runs. Using Oracle SQL Developer we ensure that our business runs smoothly.
Pros
The various contents of a database can be viewed using the connection tree
We can run SQL queries to generate reports in various formats
Debugging of queries is smooth
Cons
More RAM usage by SQL Developer which makes it slow sometimes for big queries
The database automatically gets disconnected when it is idle for sometime
Auto-completion of queries is not available
Likelihood to Recommend
SQL Developer is well suited for solving production issues by doing data fixes. SQL Developer is well suited for extracting reports from database. It is well suited for debugging queries. It is well suited for designing and developing new database.PL/SQL development can easily be done through it. It is best suited for doing DML and DDl updates of database.
In the part of the data migration and integration process, we are analyzing end-points in front-end and in back-end also. For backend data analysis and extract purposes, we use the Oracle SQL developer tool for DB connectivity. It works fine with Oracle and also relational databases. We mostly work on SQL developer editors for SQL, PL/SQL query testing, executions, and data extracting from instances.
Pros
The efficient connectivity with various Oracle and relational databases.
The options for fastest query building and execution. The debugging options also displays exact error message of the query, if any bug in query.
We can export extracted data in various file formats.
Simple user interface and effective functions for user friendliness.
Cons
When the connected database is disconnected due to some issues, the re-connection option does not work properly all the time.
For the long time executions, tool gets unstable state.
The report and documentation features need to updated.
Likelihood to Recommend
The Oracle SQL Developer tool performing well in most of the data analyzing process stages except one or two processes. We can develop and analyze SQL queries by connecting multiple databases in a single frame. In the complex or huge line query executions, we cannot find the exact execution status. It needs to be added for better understanding in the execution stage.
VU
Verified User
Consultant in Information Technology (1001-5000 employees)
I create web and desktop applications which use SQL developer as back end and stores all the data in it. It is used by whole department and all the users to read and write. It used to maintain historic data and generate monthly reports. It's also help us to generate multiple queries and format the data when needed
Pros
Better Performance
Good User interface
Advance Options
Big Data
Cons
Syntax
Intellisense
Type casting
Likelihood to Recommend
There are many scenarios where Oracle SQL Developer is suited. Where we need historic data and huge amount of data is need and searched every minute this help us for fast response from data base. When organizations need strict business and regulatory requirements. Oracle works best with Linux environments and gives best performance results.
[Oracle] SQL Developer is a free to use IDE that allows to manage and use Oracle databases both on premise and in the cloud. We used it in the different development teams to design and develop Oracle databases, allowing to easily create tables, views, procedures and functions. We also used some of the features to troubleshoot or monitor small incidents (like performance bottleneck) in our development and testing environments.
Pros
Ability to browse across all database components and easily modify or drop them, or create new ones.
Very simple to use and learn, yet includes many personalization options (like snippets and SQL history)
You can define window border colors for different connections, thus easily identifying production or sensitive environments at glance!
Import and Export data in a very simple way
Cons
Being a JAVA application, response times are sometimes not as good as native applications
Sometimes it uses more RAM than expected
Sometimes gets disconnected from DB
Likelihood to Recommend
<div>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. </div><div>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.
In our company, Oracle SQL Developer is using by Oracle developer by default in AppDev department across the global. We use Oracle SQL Developer since Oracle 11g, replaced the license product Toad for Oracle. Oracle SQL Developer able to provide all the feature required by database development activities.
Pros
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.
Cons
Showing more detail on real-time database performance data
Integration with AWR report
Show more diagnostic info on Oracle RAC
Likelihood to Recommend
The Procedure Editor is a complete IDE for the PL/SQL programming language. Stored Procedures, Functions, Packages, Types, and Triggers can be executed, compiled, refactored and more using the Procedure Editor. Access the Procedure Editor by clicking on a PL/SQL object in the connection tree or by opening a file with a file extension mapped to PL/SQL objects.
[Oracle] SQL developer is used as [a] graphical interface to oracle DB. The main user of SQL developer is [a] user [that] can access the DB very efficiently. It is used by [the] IT department in our organization. [Writing] and executing the query is easy and we can easily address in the query. Also, we can easily connect with multiple database through this so the work can be happen in faster way.
Pros
[You] can connect multiple databases [very] easily.
[Anyone] can write [queries] easily and see the errors.
[It] generates [an] execution plan, which helps to optimize the query.
Cons
[Good] filtering and reporting is not available.
[More] documentation should be available in software so that user will get all the help in it.
[Memory] usage should be less.
Likelihood to Recommend
When you have multiple databases to connect, it is the best software to user. [You] will get to know [the] full report for your query execution. [The] [history] feature is very useful to check [the] query. [Importing] and [exporting] data is very easy and is in various format, such as: Excel, CSV etc. [Installation] or Setup is very and [easily] handy.
VU
Verified User
Team Lead in Information Technology (51-200 employees)
We are using Oracle SQL Developer to query our data from Database. It is being used across entire organization. It helps to query data from the database also helps to conduct advance SQL operations.
Pros
Very simple UI. Also quite user friendly.
Debugging seems very easy if there is any issue.
It's a freeware and easy to install.
Also does support to connect with various kinds of databases.
Cons
When usage is really heavy, it lags a lot.
It automatically gets disconnected if haven't used for some amount of time.
Needs more detailed documentation.
Likelihood to Recommend
[Oracle SQL Developer is] best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc.
It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.