Oracle SQL Developer OverviewUNIXBusinessApplication

Oracle SQL Developer is the #1 ranked solution in our list of top IDE tools. It is most often compared to Toad Data Modeler: Oracle SQL Developer vs Toad Data Modeler

What is Oracle SQL Developer?

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.

For more information on Oracle SQL Developer, visit Oracle.com

Oracle SQL Developer Customers

Prinova

Oracle SQL Developer Video

Pricing Advice

What users are saying about Oracle SQL Developer pricing:
  • "It has the advantage that it's free. The next best competitor would cost several thousand dollars."

Filter Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Martin Klier
Senior Database Consultant at Performing Databases
Consultant
Top 10Leaderboard
Helps me streamline and unify my approach for different customers

What is our primary use case?

I usually use SQL Developer for tuning and analyzing databases, to visualise results, create simple reports and to simplify work by using simple scripts.

Pros and Cons

  • "I like it because it's very similar in output to SQL *Plus, and it has many convenience features that make it easier to read the data and use the basic reporting features it provides."
  • "It's easy to deploy, I can copy it onto the system and run it without having to install it and this makes it a very good solution for quick use."
  • "I think it would be great to have an overview over the sessions it opens so that we could easily see and control which connections to the database we want to keep open, which ones are hanging; and it would be great to make them independent from each other."
  • "Scalability has room for improvement. Often if you have to do a heavy load of queries or are getting large result sets you have to be careful not to overload the Java virtual machine that's running."

What other advice do I have?

I think you should make yourself familiar with this product and get into the core functionality first, before making a decision. I would rate it a nine out of 10 because I like its features, how well it is integrated into the core Oracle Database, and it's the first choice when you have to do stuff within the database.