Filter Ratings and Reviews
Filter 463 vetted SQL Developer reviews and ratings
Reviews (1-25 of 75)
Companies can't remove reviews or game the system. Here's why.
May 13, 2021
[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.
- 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
- 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
Yes - I'm a member of AROUG (Argentina Oracle User Group) and I really value the chance of sharing experiences with members of the group and with the entire community. I've participated since 2013 in former OTN Latin America Tour as a speaker, both in Argentina and Uruguay, and last year even at global level since the tour was done online.
April 29, 2021
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.
- 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.
- Showing more detail on real-time database performance data
- Integration with AWR report
- Show more diagnostic info on Oracle RAC
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.
- 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.
- 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.
Not yet, but I'm interested in Oracle user groups
May 14, 2021
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
- Better Performance
- Good User interface
- Advance Options
- Big Data
- Syntax
- Intellisense
- Type casting
SQL developer is a tool used to access the database of various applications. It can be used to access multiple database / schemas simultaneously.
The Database & Application team were using the SQL developer to access the client DB for verifying the data stored in application.
Earlier, we did not have common tool to access DB and was having few issues. Later it got resolved with SQL developer.
The Database & Application team were using the SQL developer to access the client DB for verifying the data stored in application.
Earlier, we did not have common tool to access DB and was having few issues. Later it got resolved with SQL developer.
- Able to query the DB and get results easily and can easily execute scripts.
- Able to connect with multiple schemas / DB simultaneously.
- Able to export the results in required format (Excel / Csv)
- Able to customize the features that are required.
- UI of SQL developer is nice and easily accessible.
- Inconsistency and data incompatibility in date and time syntax, string concatenation and is case sensitivity.
- Reconnect menu item does not always work when the database has been unexpectedly disconnected
- Not stable when query is taking long time to execute
- When reconnected to DB, the previous SQL query window could have been opened instead of opening new query window
Yes - I belong to Oracle community, where I will be discussing on the issues faced while installing, configuring SQL Developer & connecting to different schemas. Also discussing regarding execution of query, optimization of query so that, results can be obtained easily (without any crashing of application). By being member of group, I got more technical knowledge about the application and its usage.
April 15, 2021
My organization is using Oracle SQL Developer as the main interface utility for a large patient related database. Oracle SQL Developer functions as a report writing tool, maintenance, upgrade validation, and testing utility.
- Easy interface with large selection of useful utilities.
- Import and export of pre-configured SQL connections for easy duplication.
- Snippets, history, and other utilities add quick custom functionality.
- Some database design tools found in other SQL tools are not yet available.
- Customizing utility windows does not save after restarting application.
April 13, 2021
Oracle SQL Developer is used by each and every department in my organization but not all employees work on it. Mainly it is used to store data my organization works on. It is used to keep records of my company for a long time without any need to delete--also hassle free maintenance of data.
- Simple UI. Even new joiners can easily use it.
- Autocomplete feature. It recommends a completion for every line.
- Debugging is easy. Oracle SQL Developer displays what ever the error is.
- Supports various kind of DB. Not just SQL.
- Easy installation and setup.
- It is free to use and one doesn't need to buy anything.
- Easily export data into different formats like Excel, TSV file, text file, html, etc.
- There are fewer features compared to other software available in market.
- Good quality reporting, sorting ,filtering features are not available.
- Lags upon heavy usage.
- Connection from DB gets disconnected if query is stopped.
- Query running status still comes even if at the backend the query has been stopped and person keeps on waiting.
Oracle SQL Developer is the primary tool used by me and my team to query the databases and make changes to them. It is one of the best and reliable tools available for SQL development. We are using SQL Developer in many of the application servers to query the production databases and generate the reports.
- Easy to install and use.
- Freeware
- Best user interface with many options.
- Regular updates and support from Oracle.
- Needs more detailed documentation for certain inbuilt UI options.
- Command Line needs to be improved with more options.
April 09, 2021
Oracle SQL Developer used by different groups for running queries, scripting, and compiling packages and procedures, etc . It really helps to connect multiple database at same time and manage day to day activities for end user needs.
- Build and analyze SQL queries by connecting multiple databases.
- User friendly GUI and easy to navigate through various features easily.
- Import data easily from text files, Excel files, and CSV files.
- Easy to install and config.
- It uses lot of system memory.
- Lack of scheduling jobs.
- Export or import data from on-prem to cloud and vice versa easily.
- Nice to have drag and [desktop] feature.
Yes - IOUG, UKOUG - The user groups are good to share and learn.
May 06, 2021
One of our project customers prefers to use Oracle SQL Developer. It is quite unusual, but I have discovered the standalone version: we can also run an Oracle client without installation. We can import data from excel and other sources, it simplifies the insert data process. UI has a nice design, intuitive and reliable to write native SQL and operate with tables.
- The dashboard is easy for navigation: everything where it should be.
- Tables and columns are nicely displayed. I can operate with constraints and indexes.
- SQL queries are easy to run and debug.
- In case of misspelled or other situation - the error could be easily located.
- Oracle client is very developer-oriented, not for the regular operators.
- Consumes a lot of memory, need to be ready to enlarge RAM.
- Only 1 query could be run at the same time in 1 Database.
Not yet, but I'm interested in Oracle user groups
June 04, 2021
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.
- 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
- 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
May 18, 2021
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.
- 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.
- 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.
April 27, 2021
[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.
- [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.
- [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.
Not yet, but I'm interested in Oracle user groups - [N/A]
Oracle SQL Developer is used across the company by different users depending on their preferences. Since it’s free, anyone can download and use it. It is best SQL editor for Oracle and other databases--lots of features and easy to use. It’s reliable and performs better than other similar tools. It helps database users to query, manage data in large enterprise databases like Oracle and Teradata. Oracle SQL Developer also has features for database migration, data modeling, data mining, import/export, versioning, analytics reports, change management, debugging, and logging.
- Database querying SQL
- Data modeling and design
- Database explorer
- Data filtering, export/import
- Database object management
- Data migration
- Debugging
- Version control
- OLAP
- Analytics reports
- Sessions
- Database comparision
- Better user interface
- Native support for other databases
- Autocompletion
- Performance
December 12, 2019
SQL developer is still being used as one of the main tools for manipulating our databases. Although for development, the built-in tools suffice, this professional tool is still used widely by our DBAs. A reliable, and well-supported tool, which is excellent to utilize the power of PL/SQL and Oracle databases.
- Database manipulation and SQL editing.
- PL/SQL code development.
- Modern IDE like features, like wider linting support.
- More customization.
Yes - Hungarian Oracle Users group. We have regular meetups, and a big community, which provides us with many job opportunities, as well as knowledge and experience sharing.
We have 3 Oracle DBAs in our group. We use SQL Developer every day for running queries, writing script, running dml, ddl and compiling packages and procedures. We also use SQL Developer for administrative functions, such as creating or manipulating user accounts within the database. SQL Developer helps with organization of connections to multiple databases by allowing lots of connections to different databases and allows you to create folders.
- DML and DDL.
- Organization of connections to databases.
- Export and import of external data.
- SQL Developer does most everything TOAD can do.
- Easier way to manipulate packages and procedures.
- Better documentation and location of documentation easier to find online.
- Maybe a little better look and feel to the GUI.
Not yet, but I'm interested in Oracle user groups
I am a database administrator and I have recently started using SQL Developer command line (12.2) since it's been enhanced to be a successor to SQL Plus. I have always been interested in the graphical SQL Developer but as a dba, I required the command line functionality of SQL Plus. Now that SQL Developer command line exists, I have started using it. I really like some of the functionality but I am very new to using SQL Developer and wish that more robust documentation was available. I often find there are things in SQL Plus that I cannot do in SQL Developer command line, and I am unable to find the answers online. Using SQL Developer command line allows me to better perform my job functions as a dba.
- Extract DDL for tables and indexes.
- Provide statistical information from the data dictionary in an easy manner.
- Help interface for command syntax is good when it works.
- Help for legacy commands from SQL Plus- Some commands are deprecated but there is no explanation for what type of syntax to use instead.
- Ability to start SQL Developer command line in the directory from which the command was launched (instead of SQL Developer home).
- Spool without control characters.
December 02, 2019
Our full department is using Oracle SQL Developer. It is used by the business intelligence team to run queries and manage the reporting database. It is also used by developers to manage production databases and run their own set of tests and reports. It addresses the issue of having a single area for everyone on a team to manage the same environments.
- Oracle SQL Developer's navigation bar has a lot of useful tools. When first learning how to use this product, it was very easy to move around and figure out what needed to be done.
- This product allows you to organize schemas on a side bar view, which is very useful when working with multiple databases.
- You can customize schema names to your liking, it does not have to be the same as others on the team.
- Oracle SQL Developer is not the best tool for extracting data. If you want an excel sheet for all the outputted result data, it can take a very long time. This is tough for business users.
- This tool does not allow you to monitor a system that is running as easy as other products similar to it.
- Oracle SQL Developer is not as advanced in functionality as some other tools. For basic developers, this tool gets the job done. For more complex database management, I would suggest other software.
November 15, 2019
Oracle SQL Developer is our go-to application when needing to run quick queries against Oracle, get a quick overview of our schema, extract various DDL components, and other basic Oracle functionalities. We have never used it to do any Oracle DB Management or the like, preferring to go command line in these instances.
- Build and analyze SQL.
- Extract DDL.
- Provides a quick overview of the Schema Structure.
- Clunky, could use some basic UI improvements.
- Returns only 100 lines at a time when querying DB.
- Basic Oracle management functionality would be nice (check sizes of tablespaces, etc).
Yes - I am a member of various Forums and user groups for Oracle and Java. I primarily use Oracle's user groups for Oracle related information, but use a plethora of Java sources when searching out Java problems.
SQL Developer is currently used by our IT department. Various business users also have SQL Developer, but we discourage that in favor of business reports being written by our IT and BI teams. Some users in our IT department use TOAD, instead. Because SQL Oracle Developer is free, it is the preferred choice by management. Having an application to query our databases allows non-expert users to write and query SQL without the use of command-line applications, like SQL Plus. This "user-friendly" attribute is appealing to non-DBAs.
- SQL Developer is useful for navigating the DDL of a table.
- Easy-to-understand errors and explanations on incorrect queries.
- Quick load time of application from start-up.
- Explain plans are very helpful in tuning.
- 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.
Not yet, but I'm interested in Oracle user groups
SQL Developer is used at Duquesne Light Company to query our Oracle Utility Suite databases (CCB, MDM, MWM). We use it for standard selects, DDL and DML. It is being used across multiple departments in both IT and non-IT disciplines. It is also used to build reports. It addresses the need for a simple user-friendly database connection and querying tool for those who know how to write SQL and need information from the OUS databases.
- User-friendly.
- Easy to install.
- Allows users to write PL/SQL.
- You can't run more than one query against the same database at one time. This is a capability for TOAD.
- Sometimes it doesn't allow you to use parallel threads in query execution and the error message isn't very descriptive or explain why.
- Editing your display preferences could be a little easier. I had to watch several YouTube videos before I was able to figure out where those settings are kept.
Yes - Oracle Utilities Meter Data Management User Group. It's good to learn from a larger community of users who are going through the same implementation, upgrade, defect, or patching issues we experience. Some users have provided very good, simple ideas for how to improve our implementation of the software product and are eager to help.
October 13, 2019
SQL Dev is used for all of our Oracle databases for analytics. We've chosen SQL Dev as a reliable product, and will continue to use it indefinitely.
- Ease of use.
- It's designed with human factors in mind.
- Continuous improvement.
- More color scheme options.
- Query development help.
- It could use more specific query errors than the generic Oracle codes.
Oracle SQL Developer is used by developers in Stanford for retrieving data for reporting purposes. I take the necessary data and use Excel or report tools to create reports for management. We also use the application to create quality control scripts for the application that we support for our users.
- It's easy to navigate among the dashboard.
- It's easy to find errors when debugging.
- It's easy to run SQL scripts.
- To more easily go back to the dashboard that I had set up before.
- Finding tables and Views more easily.
- Finding certain columns and which tables or views have these.
Not yet, but I'm interested in Oracle user groups - I would like to be part of Java and My SQL.
October 09, 2019
Our database administration team is using Oracle SQL Developer for the sake of increased productivity. Instead of writing SQL queries out, they use Oracle SQL Developer's IDE interface to quickly create complex queries. Some other features we use include browsing/managing data, ad-hoc reporting, migrating 3rd party RDBMS systems over to Oracle, and data modeling.
- Flexible GUI. The UI updates of the latest version have made navigating through the various features of Oracle SQL Developer quite easy.
- Great Tools for Testing and Developing SQL Scripts. SQL scripting can be a hassle when working with large tables and such. Oracle SQL Developer makes it easy to preview how many rows and tables will be affected.
- Ability to Load Data from Different File Formats. Some of our data comes in the form of Excel spreadsheets, XML, and JSON. Oracle SQL Developer allows our database administrators to easily push the data from these formats into our database tables automatically.
- 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.
September 18, 2019
Oracle SQL Developer is being used by our development team to provide introspection to the performance of our production baseline. Additionally, it's used during development to pilot capabilities, integrations and for rapid proof of concept implementation.
- Seamless database management integration
- Process stack analysis
- Modeling and visualizations
- Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
- Detailed analysis of models can be clunky for complex relational models.
Yes - I was a member of NoVAJUG (Northern Virginia Java Users Group) for years. There's deep value in learning from peers and colleagues alike. User Groups provide a unique experience where there's a cross-section of ideas, industry around a common technology vertical or problem domain. For me, it's helped with everything from finding solutions to nonobvious system issues to finding leads for new employment.
SQL Developer Scorecard Summary
What is SQL Developer?
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.
Categories: Integrated Development Environment (IDE)
SQL Developer Video
What is Oracle SQL Developer?
SQL Developer Competitors
SQL Developer Pricing
- Does not have featureFree Trial Available?No
- Has featureFree or Freemium Version Available?Yes
- Does not have featurePremium Consulting/Integration Services Available?No
- Entry-level set up fee?No
For the latest information on pricing, visit https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html
SQL Developer Technical Details
| Deployment Types: | SaaS |
|---|---|
| Operating Systems: | Unspecified |
| Mobile Application: | No |
Frequently Asked Questions
What is SQL Developer?
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.
What are SQL Developer's top competitors?
Who uses SQL Developer?
The most common users of SQL Developer are from Enterprises and the Information Technology & Services industry.