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.
Oracle SQL Developer - Free Rool
Great lightweight tool
Oracle SQL Developer the Masterclass for Database Work
One of the fine IDE tool - Oracle SQL Developer
Oracle SQL Developer True Review
Free, simple to use and complete development IDE for Oracle databases
Oracle SQL Developer, a productive tool for Oracle developer
Oracle SQL Developer: One of the best Softwares I Have Ever Used
Easiest SQL IDE
Intuitive and powerful, provides tools and utilities users to handle advanced user requirements
Software for everyone using DB
Must-have SQL editor
Easy to use tool for day to day needs - SQL Developer
SQL Developer Review
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
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?
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
Comparisons
Compare with
Reviews and Ratings
(491)Attribute Ratings
Reviews
(51-72 of 72)The only SQL development tool most people need.
- 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
Not the best, but better than most
- 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
SQL Developer Review
- 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.
Why Should i Trust SQL?
- 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
SQL Developer for the first timers
- 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.
Oracle SQL Developer does basic stuff right
- 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.
Sql Developer - Great tool for Database management
- 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 Review
- 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.
Oracle SQL Developer : An easy way to manage DB
- simple and immediate graphical interface
- no installation
- easy import and export DB schemas
- keep hold query results after closing
- more extensions
SQL Developer - Free Tool for Oracle and other databases.
- 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.
Less appropriate for Non SQL related tasks
SQL Developer, a tool for everyone
- 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.
Manages the giant with another giant
- 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.
Free tool used for Oracle Database development
- 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.
The right editor for all your DB related operations
- 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.
Oracle SQL developer, a swiss army knife for DBAs
- 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.
SQL Developer, the best gui tool for Oracle
- 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.
Review of Oracle SQL Developer
- 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
A good database development tool: SQL Developer
- 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
SQL Developer Development
- 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.
- 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 Developer - Light Weight PLSQL Code management
- 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.
SQL Developer - The Last Resort
- 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.