Easy data surfing
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 …
Overview
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.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
Pricing
N/A
Unavailable
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.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
7 people also want pricing
Alternatives Pricing
What is Rider?
JetBrains supports .NET development with Rider, a .NET IDE based on the IntelliJ platform and ReSharper.
What is The Welkin Suite?
The Welkin Suite offers an integrated development environment with 105 features (and growing). The vendor aims to help you automate the chores of development, and therefore enhance your coding velocity and increase the quality of your deliverable code.
Product Details
- About
- Competitors
- Tech Details
- FAQs
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.
SQL Developer Competitors
SQL Developer Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Frequently Asked Questions
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.
Reviewers rate Oracle University Experience highest, with a score of 7.9.
The most common users of SQL Developer are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(489)Attribute Ratings
Reviews
(1-25 of 49)Companies can't remove reviews or game the system. Here's why
December 21, 2023
Easy data surfing
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.
- Export Data
- Run SQL statements
- Browse Database Objects
- Search for a specific object in the database
- Debug
December 21, 2023
Oracle SQL Developer - Free Rool
We utilize SQL Developer as the IDE tool to connect to the Oracle Database, although we don't employ all of its functionalities. Our primary use of this tool is to retrieve SQL queries and debug packages. The entire object structure is managed in a GitLab repository, and all scripts are executed using VS Code.
- Structure Oracle Database objects
- Intuitive navigation
- Export Data
- Java dependency
- Autocomplete issues
Score 8 out of 10
Vetted Review
Verified User
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 19, 2021
One of the fine IDE tool - Oracle SQL Developer
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.
May 14, 2021
Oracle SQL Developer True Review
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
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
April 15, 2021
Intuitive and powerful, provides tools and utilities users to handle advanced user requirements
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
Software for everyone using DB
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.
April 12, 2021
Must-have SQL editor
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
April 09, 2021
Easy to use tool for day to day needs - SQL Developer
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.
December 13, 2019
SQL Developer Review
We use SQL Developer in our IT organization as well as in our functional side of the organization as well. It solves our issues for querying the data being open source and free and also have a very intuitive GUI to easily write queries and DB packages.
- Ease of writing SQL queries and fine tuning it.
- Very intuitive GUI.
- It's a very heavy tool, and it doesn't work well with low memory computers.
- It's doesn't show users the TNS entries for databases.
December 09, 2019
SQL Developer FOC
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.
December 04, 2019
SQL Developer Review
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.
November 16, 2019
SQL developer for dummies
SQL Developer is used in our organization by our department and by some other business users. SQL Developer is a freeware that comes with no additional cost, which is appealing to users and helps in connecting to multiple instances of Oracle EBS and other Oracle related applications. It has no licensing or cost issue, and we can query and develop various database objects. SQL Developer fetches query results in different formats like in Excel, Text, etc., which is user-friendly, unlike the command line SQL Plus, where you have to use formatting options.
- SQL Developer is easy to navigate and open database structures like tables, packages, procedures, etc.
- Easy to connect to set up database connectivity using service name/SID information.
- SQL Developer UI is very simple to understand and operate by the users and has a quick connect and load time of applications.
- Easy to check the Explain plan assessing the cost of the SQL queries and thus helping in tuning.
- Lacks the advanced options for a professional developer like accessing the dependent objects of a particular database object like Indexes, triggers, etc.
- Lacks features do not have the SQL session monitoring capability and managing other Oracle sessions.
- It does not give a clear indication of query status, whether it is running or stuck.
November 08, 2019
Great for non-DBA users
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.
November 07, 2019
Oracle SQL Developer paves the way
Oracle SQL Developer is used by our entire organization but in my department, I know we use this daily and pretty heavily. We use SQL Developer to quickly and easily pull data dependent on certain criteria, often there would be no other way to gather this kind of data without the help and database of the Oracle SQL Developer. This functionality serves us with requests from the business side for meter configurations, sample meter tests for the years exchanges, time window accruing Field Activities that need to reapply, and hundreds if not thousands of other functions that apply. Often, there is something brand new to us that we use this tool to help us narrow down what data we are looking for.
- Searches for and gathers data quickly and efficiently.
- If you error during writing your queries, this usually provides accurate reasons why your query errored, allowing you to quickly make the correct fixes.
- Allows for customization.
- I am stretching to come up with cons for SQL Developer, it could possibly have more tips and tricks for easily writing queries. Maybe more user-friendly functionality.
October 31, 2019
Oracle SQL Developer: my daily work buddy
Oracle SQL Developer is a popular tool we use here at our organization. Developers, DBAs and data architects all use this tool. We use it for running queries, DBA administration, and Data Modeling. In the DBA section, it provides database configuration - initialization parameters, current database properties, and database stats—the instance viewer is super nice.
- DBA section: automatic undo management, initialization parameters, database feature usage, instance viewer (CPU, session, top SQL, processes,etc.).
- Memory/storage: beautiful graphics, performance, backup/recovery, security (roles, users, profiles, and auditing). All is nicely displayed!
- SQL Worksheet: I can run queries in a database, hop to a different database, run the same query or different one. All can be done in one console.
- I have connections set up for 40 databases, switch between databases - very convenient. Queries can be kept in History or save to a notepad.
- Tools: 1.Modeling is a nice addition in SQL Developer. I don't use it for creating logical models. However, I find it very helpful to look at the model and understand the relationship between tables and schemas.
- Database copy: make a copy of the database from source to destination with many different options - object copy, tablespace copy, schema copy, copy DDL, copy data.
- Database diff: make comparisons between databases
- Database export with many options based on requirements.
- SQL Worksheet: listed above
- Session monitoring: who is logged in.
- Real-time SQL monitoring: insight into how to tune a poorly written query. It does, however, need an additional license.
- General: tables are nicely displayed. I used it every day. I can see column, data model, constraints, grants, statistics, triggers, dependencies, partitions, indexes and I can generate SQL DDL!
- A dashboard to display database status: all database connected/registered, general info, database up/down, version, size and which server it's on.
- Schedule jobs to be run.
October 13, 2019
Comparing SQL Dev to Toad and SQL Nav
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.
October 08, 2019
SQL Developer is amazing!
We use Oracle SQL Developer to extract, create database objects such as views, stored procedures, packages, etc and to also report out info. We use it in the IT department. I find it to be a generally good tool.
- Run queries
- Export Data
- When displaying errors it locates the error on the exact line and position.
- I would like to drag and drop from and to any of the areas.
- I would like to have more capabilities to export.
- Have help info handy when I have a doubt with extensive help.
September 30, 2019
Easy-to-use tool
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.
September 26, 2019
Oracle SQL Developer
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.
September 18, 2019
Oracle SQL Developer Review
Oracle SQL Developer is the choice of product to write pl/sql code and is easy to connect to multiple databases. This is a tool which allows to connection to Oracle products as well and hence why it is useful when you need one glass pane for all your tools.
- Oracle SQL Developer is one glass pane to look for all connections across all databases.
- This can work across various environments and provides good value for money.
- This is developer oriented and maintains great connection pool to databases.
- Not easy to install - our IT and compliance policies made it hard to get this installed.
- If there are security policies across companies, it is not easy to work way out to get product installed. The product is good, but the way it is delivered is not the best.
- This product need better UI to search data across various panes.
Oracle SQL Developer is used by my department. It is used for writing and testing SQL scripts, for debugging as well. It is also used to mostly access the data used for data analytics.
- Easy to install.
- Good for debugging SQL scripts.
- Exporting to Excel.
September 17, 2019
Analyst's Review of Oracle SQL Developer
Oracle SQL Developer is our default querying IDE for our analytics zone and a primary way for us to access all the data we store across various programs.
- Easy to connect to a data source - Time to get started is fairly easy given the connection is straightforward.
- It's very barebones, there are so many greater options for querying that provide more dynamic interaction and autocompletion.
- Visually, it leaves much to be desired, sometimes it even clips the text on my widescreen monitor.
April 08, 2019
Simple SQL software that is easy to use
SQL Developer is used by some of the programmers and database administrators. We use it for data fixes in Oracle databases along with processes in PL/SQL to update a lot of data. It works well to do complex or simple data updates and is easy to pick up for new programmers.
- Easy to use UI.
- Fairly quick software with right Java versions, etc.
- Formatting feature is good.
- Explain plan feature is great.
- Canceling queries (at least in older versions) didn't actually cancel queries; it still had to do the entire query then rollback.
- Out of sync versions of java make SQL Developer run terribly, I've had this happen on a virtual machine and I no longer use it there.
- Setting defaults for login/etc. With files isn't so simple even for newer versions.