Skip to main content
TrustRadius
SQL Developer

SQL Developer

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.

Read more
Recent Reviews

Must-have SQL editor

7 out of 10
April 12, 2021
Incentivized
Oracle SQL Developer is used across the company by different users depending on their preferences. Since it’s free, anyone can download …
Continue reading

SQL Developer Review

9 out of 10
December 13, 2019
Incentivized
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 …
Continue reading
Read all 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

View all pros & cons
Return to navigation

Pricing

View all 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.

Return to navigation

Product Details

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 Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

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.

Microsoft SQL Server, Microsoft Access, and DBeaver are common alternatives for SQL Developer.

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).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(491)

Attribute Ratings

Reviews

(51-72 of 72)
Companies can't remove reviews or game the system. Here's why
George Robbins | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is being used by the data management team at my current climate to do data analysis and data preparation. It is the starting point for most reports and also where we merge data from multiple data sources. Very few business people have any knowledge of SQL and so they need the team to use SQL developer for bother recurring and ad hoc queries.
  • Performs well even with large amounts of data
  • Helps finds SQL errors before runtime
  • Easy to install and upgrade.
  • Embedded documentation for PL/SQL functions is lacking
  • Integrations with other data sources
  • Not useful if you don't have strong SQL skills
If you have an Oracle Data warehouse, then you do not actually need a different IDE for your data development. In the past, it was necessary to have TOAD or something similar, but now the new versions of SQL developer allow it to be used for most use cases. Very stable and great for analysts and DBAs.
Nefi Bernal | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is used to mining data and completes several data analysis tasks.
  • provides data profile
  • separate result windows
  • schema organization
  • assistance while writing statements, it actually provides a title assistance where others provide none, but i think it can provide more in order to make easier and faster for the developers
As far as an SQL platform it is a great option, the only downside that it may have is training and support. They do build it to be very simple but it would be nice if they were to provide training for the advanced features.
Kartik Chavan | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Congratulations for SQL Developer, this is an amazing tool which saves me a lot of work and can be compared with professional classic tools like TOAD. For accessing our databases Oracle SQL Developer is a very popular tool in our company. It being available for free, it is also capable of interfacing with SQL Server. It is very simple to use and provides a great value to all the departments.

  • Very intuitive user interface
  • Easy Data Manipulation Language operations like inserts, updates, and deletes.
  • It highlights the syntax errors
  • Some queries are not stable
  • No machine learning features
  • Difficult to terminate a running query.
They need to improvise on extraction of data. It is really a great tool for any type of SQL queries. It can be used for custom queries and reports. This being free, it has a lot of features compared to other non-free tools. Hence, I would always want to use SQL Developer.
January 31, 2018

Why Should i Trust SQL?

Luigi Vecchione | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SQL Dev is being used in different projects since I'm working for a Consultant Company, it's totally related to the project requirements. It's so helpful to manage and query all the DWH instances and the database themselves.
  • Great Activity Monitoring
  • Great Management of Databases and Objects on the instance
  • Great Query Optimization module
  • Machine Learning Functionalities
  • Auto-format of the code
  • Resource Management
Well suited for management of dwh both in small than in big sizes. Not really suitable for Big Data Management.
Brandon Johnson | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is mainly being used by my department. Other areas do not use it, they much rather use TOAD. Though, a lot of areas do not use SQL at all also.
  • It honestly is a great tool for being able to find errors in code.
  • I taught myself how to do SQL within SQL developer.
  • There are great support pages/Youtube videos online.
  • I wished that it truly pinpointed every error exactly as we see it. Usually, it is not the case.
  • Sometimes, the actual system can freeze up on you (Has happened to me on both home and office network numerous of times) but I expect it sometimes due to the amount of data.
  • Honestly, they could improve extraction of data.
I think SQL developer is great for anyone who needs to query a DB and create different views. I can use it to quickly access the data that we house for governance purposes.
heather collins | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle SQL Developer is a very robust tool that we use in our company for accessing our databases. It can be downloaded for free and is capable of interfacing with non-Oracle databases like MySQL, SQL Server as well. It is a very simple tool and offers good value to both DBAs and developers alike.
  • With an intuitive user interface, Oracle SQL developer is great for point and click DML operations like inserts, updates, and deletes.
  • It's available for free from Oracle's website and gets frequent updates as well.
  • I found that integration with non-Oracle databases like UDB can sometimes be tricky with downloading third-party database drivers.
  • Some versions of this application have been slightly unstable and have frequently needed updates to the Java JDK installations.
Oracle SQL Developer is ideal for everyday common database CRUD operations. It is also helpful in formatting SQL queries into Java code and vice versa.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is being used within IT to control our databases. It's used to run queries, create reports, database administration, and for data modeling. Oracle is our ERP and SQL Developer is pretty much the easiest way to make changes to and get information out of our databases.
  • Run SQL statements and SQL scripts.
  • Create and save custom reports.
  • Cant really terminate an executing PL/SQL procedure once it has been started.
  • Export function can be buggy at times.
SQL Developer is well suited to create reports that are not readily available as a seeded report. It also makes it easy to make changes to seeded reports (adding/removing columns, calculated columns). Database monitoring as well as connecting to third party databases for monitoring is also simple. The tree based object browser makes it easy to navigate where you want to go.
November 30, 2017

SQL Developer Review

Dan Hotka | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I use SQL Developer (SD) for PL/SQL development. Being free from Oracle Corp, it is a very cost-effective way to build and maintain PL/SQL code. I like the main editor window that I can execute PL/SQL or SQL and get results. The SQL can be easily saved for future use in the form of a report. There is a nice history function that shows all of the code (last 100 things done I think...) SD executed. This feature is particularly handy when doing some SQL tuning with hints. Another nice feature is that SD supports the APEX environment, right out of the gate! You can easily view the APEX management data right from SD. SD also has code snippets and some code templates. The code snippets are drag and drop bits of code useful for various functions, SQL tuning (there is a category for all of the useful SQL hints), date functions, date/time masks, number/character conversions, and more. I have plugged my various useful SQL into the SD reports making them very easy to run.
  • PL/SQL Development: the tool's strength really. SD supports code condensing, parentheses/brace matching, insites (popup windows with data object column names, etc).
  • I like the report feature...very easy to add your library of SQL to be run as reports. SD works with bind variables in your SQL well too.
  • The history feature is particularly nice. It's called SQL Recall and it saves quite a number of PL/SQL and SQL code you have been working with for near-future reference and recovery if needed.
  • The code snippets is very nice. Various functions and function details at your fingertips. Use a drag and drop operation to add to your code.
  • SQL Tuning. SD has explained plans but these could easily be improved upon using the latest features of the Oracle RDBMS.
  • More code templates. You can add your own but the tool seems to be lacking a bit when it comes to pre-existing code examples.
  • Smaller foot print. The thing is huge and somewhat slow.
  • Seems every time I get a newer SD, I also have to upgrade the Java environment as well. Would be nice if they picked a rev of Java and stuck to it.
SD is well suited for PL/SQL development, some data analysis, and executing of SQL. The price is certainly right at 'free'... I find it not as helpful when it comes to SQL performance tuning. I usually have to resort to SQL*Plus or other tools to run the more advanced performance tuning things such as SQL Trace.
Sebastiano Manzella | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
In our company, we use a lot of SQL Developer to manage in a graphical way our customers' database. For each project we are involved, we have one or more than one database, so a fantastic tool to manage easily and quickly is SQL Dev thank to It is slim and immediate graphical interface. This tool supports our developers with tasks such as creating objects, statements and scripts Sql, editing, and debugging code scripts Pl / Sql.
  • simple and immediate graphical interface
  • no installation
  • easy import and export DB schemas
  • keep hold query results after closing
  • more extensions
Oracle SQL Developer is a professional tool for managing and organizing SQL databases. It, therefore, supports database administrators and programmers in general, who appreciate the functions developed specifically for Oracle SQL. In fact, it can be counted among the Integrated Development Environment (IDE), as it allows us to carry out typical activities of this category of applications. This integrated work environment is available in Windows, Mac, and Linux environments, showing a certain versatility of use.
Ketan Kothari | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is used for querying Oracle databases. It provides an easy way to get data from Oracle databases and also help monitor any issues within our IT department.
  • Query Oracle Database and export data
  • Provide quick overview of Database
  • Use it to Run SQL Tuning advisor and custom reports for performance troubleshooting
  • Quick to load and faster performance
  • Ability to support setting of default schema on logon automatically
  • Use thin JDBC LDAP URL instead of hard-coding server names in connection.xml. Currently, we need to use advanced and specify URL our selves.
Query Data Performance Tuning
Less appropriate for Non SQL related tasks
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle SQL Developer is used as primary SQL Development tool, across the whole organization. It's used for development using Oracle 11g and 12c database. It was also used to access IBM DB2 Database, before completely switching to Oracle DB. It's simple to use, for everyone, starting from developers to QA, to DBAs. Developers, QA, DBAs, Managers, everyone uses it, across the whole organization.
  • It's easy to use and has lots of inbuilt shortcuts, which can be customized as well.
  • Works with various DBs including IBM DB2.
  • Simple UI, with multiple tab support
  • When opening more than 5-6 connection tabs, it tends to freeze, even of a machine with latest hardware and 32 GB+ Memory.
  • The "Explain Plan" section of the query needs improvement. By default, it doesn't have CPU cost and partition details.
  • Error detail section can be improved.
SQL Developer is a great tool when dealing with SQL Databases, like Oracle 11g, 12c or IBM DB2. For No-SQL databases, like MongoDB, this isn't appropriate.
Miguel Angel Merino Vega | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
As a software developer, it is important to manage databases from a fast and reliable presentation. SQL Developer allow developers to quickly manage data on a par with project and development times. Not only that, but also gives you modeling and reporting tools that facilitate the documentation in the analysis and design phases.
  • Data modeling and reporting tools.
  • Create new databases for startups.
  • Simple data management, even in a complex environment like Oracle Database.
  • It works mainly for Oracle and does not work as easily with other databases like SQL Server.
  • Installation can be a problem if you are not used to Oracle installation process.
If you are working with Oracle Database, SQL Developer is the way to go. If you go with other databases like SQL Server you could prefer SQL Management or Toad.
Krishan Mohil | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is used by our ERP & BI Development and Support teams and our DBA team. It also is used on occasion by security and system administration folks. Programmers are looking at tables constantly. Having a graphic tool to do that makes the process quicker and easier. In the past some folks have used TOAD (which is a great tool), but over time SQL Developer has won out as Oracle has continued to add features. We just cannot beat the cost since it is free. Security and system administrators occasionally need to run scripts and SQL Developer provides a nice visual interface to do so. I am comfortable using the SQL*Plus command line.
  • Easy to use, even if someone not worked in past with it and have experience using some other tool like TOAD. It's easy to work with it.
  • It's connectivity and features with Oracle database is added advantage for users like monitoring SQLs, sessions and data modeling.
  • Getting details about existing objects with their scripts and data. Its portability into different file system like Excel, text etc.
  • Its connectivity to other databases and use of specific functions from it. Example: DB2.
  • Running many SQLs in parallel from a number of open SQL sheets. TOAD has this feature, very useful to toggle between different tabs.
SQL Developer is well suited with Oracle Database, importantly it's free with it. SQL Developer gives all the good features required by developer or admins when using Oracle Database, and it's easy to use. However, when used with other database SQL Developer has its limitations to have their features and functions.
Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Oracle SQL Developer can connect to many different database management systems, such as Postgres SQL, Enterprise DB, Microsoft SQL Server, etc.
  • Enhanced capabilities for querying
  • Ease of usage and simple UI
  • Importing Excel files to database quickly
  • Multiple query editor screens
  • Works both on Macs and Windows PCs and laptops
  • Enhanced formatting capabilities including your own query formatting
  • Comparison of saved queries and / or databases
  • Works with Data Modeler seamlesly
  • Enhanced debugging mode with break points
  • Change management support
  • Data miner support
  • OLAP support
  • REST Data services support
  • Cloud ready
  • History of SQL Statements
  • Thumbnail view
  • Git support
  • SVN support including team versioning environment
  • External tools support
  • Localization support
  • Customizable shortcuts
  • Fully customizable querying tool
  • Code Templates (can be used for commonly used statement: scf ==> select count(*) from)
  • Data and/or objects migration
  • Connection to multiple and various types of databases at once, within the same application
  • Works with files easily, steadily and with high performance
  • Mac and Windows support
  • Team coding support (git, SVN, etc.) with change management
  • Oracle special packages and additional tools (data miner, OLAP, Data Modeler, REST Data Services, Cloud and others)
  • Code templates. Shorten your most used statements (type ssf and "space" and it converts to "select * from")
  • Native JDBC support (with native connection string) for non-supported JDBC database connections.
  • Easy to install, just extract the zip file or copy your installation folder to a USB drive and it is ready to go.
  • Easy upgrades, without losing any connection details.
  • Supports CLI (Command Line Interface) for low level tasks.
Score 6 out of 10
Vetted Review
Verified User
Incentivized
We use SQL developer in our dev shop to access our database tables. It is the default product being used by the DBAs across our organization as well. Its a handy tool, that's freely available and can access non-Oracle databases as well.
  • It can be downloaded and used for free from the internet.
  • It is very useful in formatting SQL queries into Java code and vice versa.
  • It can be used for DML operations like, inserting, updating and deleting data as well.
  • It is a very resource intensive application and hogs the RAM and CPU cycles quite a bit.
  • It does not offer very easy integration with non-Oracle databases like IBM DB2 or SQL Server.
Its ideal for basic database operations like viewing some records, checking the SQL DDL for the tables defined. Also you can perform CRUD operations by just point and click technique.
Dorrie Keyes | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is used by our ERP Development team and our DBA team. It also is used on occasion by security and system administration folks. Programmers are looking at tables constantly. Having a graphic tool to do that makes the process quicker and easier. In the past some folks have used TOAD (which is a great tool), but over time SQL Developer has won out as Oracle has continued to add features. We just cannot beat the cost since it is free. Security and system administrators occasionally need to run scripts and SQL Developer provides a nice visual interface to do so. I am comfortable using the SQL*Plus command line. However when I am working with databases that I don't use very often, I appreciate the visual display of database objects as well as the easy way to get query results and put them into Excel.
  • The cost versus features factor cannot be beat since SQL Developer is free.
  • SQL Developer can automatically keep itself updated. This is great especially when working with different versions of the database. You can be sure it will be able to use all of the new features of any new release that comes out.
  • SQL Developer has reports built in for Oracle databases. I can write SQL, but having them there and easily available is a great time-saver for a DBA.
  • SQL Developer has attachment points for Git and SubVersion and access to native Oracle database tools such as export. These are great features for developers.
  • SQL Developer can be used to connect to non-Oracle databases, but they don't make it easy. Drivers must be downloaded and configured to make connections. Including these things and having a clickable select for the database type would be nice.
  • SQL Developer also has a Data Modeler. I used to use Oracle Designer 2000 and it had so many more features. Oracle promised that we could use Data Modeler instead but it does not have near the features that Designer did. It was really easy to design database tables before and Data Modeler is harder to use.
SQL Developer is great for keeping multiple Oracle database query sessions open at one time within one application. If I use SQL*Plus, I have to have a terminal server connection open first. So every SQL session is in a different window. That quickly becomes a lot of windows to keep track of. We do not use it for running automated scripts. Those are done through the command line.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We like using SQL Developer as redundancy wastes space in terms of memory and leads to larger spreadsheets. When more memory gets used, it inevitably will cost the organization more money, take longer to open and close files, and larger spreadsheets lead to more time fixing errors when mistakes or adjustments occur. Other than these issues, a main concern is that the data will be inconsistent with spelling and other detailing errors.
  • Ease of use, as the way it is viewed is much easier than other programs
  • SQL prompting that adapts to what the user may want going forward
  • Good ER diagrams that are easy to build and update
  • Easy exporting and importing techniques
  • User prompts that have vague message boxes can occur
  • Larger buttons to view options and selection areas much easier
  • Better heading ribbon to create easier navigation throughout the file
SQL Developer allows coders to take a business task and create an easy to read end product. Building views for consumer data, creating new tables with relevant information, and importing lots of data. SQL Developer does not allow for the maximum scaling and dependent on add-ons.
Paolo Borghi | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
I work in a consultancy company, which is specialized on SAP and Oracle, even if these aren't its only businesses. I work in the Oracle practice, and I've used Oracle SQL Developer since the first day I've been in my organization. Through this tool I've been able to solve a lot of "business problems", thanks to its ease of connection with many database technologies. Moreover, thanks to the many extensions that have been developed for it by Oracle and third parties, it has a great flexibility and a huge variety of tools that can be used for any purpose.
  • It's a free Oracle tool, that comes with Oracle Database
  • It allows the access to many database technologies, even if is specialized with Oracle
  • It has many add-ons, released by Oracle or by third parties, but supported by Oracle
  • It grants access to practically all the features of Oracle and similar database (i.e.: object development and management, SQL worksheet, DBA controls, database utilities, modeling and migration)
  • For its basic functionalities (i.e.: database object access) is really intuitive
  • Being an Oracle product, if you're working on Oracle Database, you can be sure to have full support on any kind of bug or malfunction from Oracle itself
  • It doesn't require being installed, but it's enough to copy its folder on an operating system
  • DBA utilities, such as resource manager and storage, are not really intuitive and may be improved
  • The graphical interface may be more intuitive and captivating: current one is quite rough, due to the low product maturity, being it a quite young product (first release in 2006)
  • It would be nice to integrate SQL Developer with Enterprise Manager, which is the main Oracle tool for db monitoring and administration
Whenever you're developing on an Oracle Database, SQL Developer is well suited. [Well suited] For creation of E-R models, schemas, database monitoring and administration or simple relational structure enquiring. To help with these tasks, you can improve your experience with this software by coupling it with other add-ons, like SQL Developer Data Modeler or other tools with specific functionalities. SQL Developer is not invasive since it doesn't require being installed. You just need to copy its files to a folder (both on a local computer or on remote) and, as you have the client for database connection, you're done. But, above all, it's a free tool! You or your organization don't have to pay anything to use it. You just have to download it from the Oracle website (like 400 Mb) and you're ready to start your work.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is being used to access Oracle DB - SQL, PL/SQL, Procedure, etc. SQL developer is a free tool with Oracle Client to access Oracle DB. We use it as a SQL query tool for all DB.
  • Thin Java client.
  • Easy to use.
  • Integrates with Oracle DB well.
  • Easy for beginners.
  • Quick to access.
  • Good formatting options.
  • Thin Java client is sometime clunky.
  • Export Data is cumbersome.
  • Modifying query results.
SQL Developer integrates well with Oracle DB. It's good for beginners, but not as good for advanced querying. It can be some time very slow. Needs a little bit more work.
Robby Tabuchi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is used by the Information Services Department as well as the Prospect Development Team. We use this software to leverage our extensive database. We have a large number of tables in our database that need to readily accessed. SQL Developer enables our teams to effectively query our database in real time.
  • Enables our team to quickly and effectively access information from our database.
  • Produces an easily readable view of the SQL scripts being written with debugging suggestions clearly marked. This helps with writing scripts in real time. I am able to see exactly where my script is creating an error.
  • SQL Developer auto completes table names, commands, functions, and field names. This is very helpful when trying to quickly write SQL script.
  • The interface is easy to navigate between input and output.
  • Encrypted connection to the database can be a little difficult especially when you have multiple database instances required for development and production.
  • The interface can be made to be a bit more user-friendly in terms of troubleshooting and suggestions for better utilization of the software.
  • Default settings should be easier to set such as keeping the line numbers in view at all times.
SQL Devloper is well suited for querying very extensive databases. This software allows you to explore and access large amounts of information very quickly. The user can leverage important information from many different tables of data. It is quite easy to create and execute complex code scripts to access very specific data. The software enables the user to review and debug the sql language very easily. SQL developer can also be used to quickly input data. This software has a medium difficult learning curve and requires sql writing training prior to use.
Advait Deshpande | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
We use SQL Developer to connect and store databases for all our environments. All tables, stored procedures, functions, and triggers are managed using SQL Developer. Since we deal with OBIEE, our code primarily consists of PL-SQL supported by Oracle and hence SQL Developer works best for us.
  • Connecting to databases. Segregation of various connections.
  • Easy availability of the tool. No cost or licensing involved.
  • Display of compiler errors.
  • It becomes slower when dealing with large volumes of code.
  • Sometimes the connectivity is lost if the network/domain is changed. It needs to be more powerful.
  • I think more detailed explanation of error logs needs to be present. It helps in debugging of code.
For PL-SQL procedures and functions, SQL Developer is best suited and highly recommended.
Brian Martino | TrustRadius Reviewer
Score 1 out of 10
Vetted Review
Verified User
Incentivized
SQL Developer is not directly used by my organization and for good reason. We are, however, forced to use it when we connect to our customer's networks and they sometimes have this as the only software available. This software allows us to connect to their various databases.
  • Easy installation. It is very simple to install SQL Developer.
  • Database connections. It is very simple to connect to a database using SQL Developer.
  • Speed of access. It is very quick to obtain a database connection using SQL Developer.
  • Viewing LOBs. SQL Developer does not support viewing large object types well.
  • Nested result sets. SQL Developer does not support showing data from REF CURSOR's or inline nested results.
  • Slow performance. SQL Developer is slow in general compared to other tools in this space I have used.
Only when nothing else is available do we use SQL Developer.
Return to navigation