SQL Developer is a must-have for Oracle
Updated January 14, 2019
SQL Developer is a must-have for Oracle
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle SQL Developer
My team and I use SQL Developer to develop and test database queries implemented in and for our various end-user reports. SQL Developer is used by other teams throughout the organization for various other purposes. By using SQL Developer, I am able to quickly and easily write, execute and debug queries. I am also able to generate and explain plans to help me evaluate and tune queries for the greatest performance.
- Highlights syntax assisting in the proper development and completion of statements.
- Allows toggling of breakpoints for SQL debugging. By using these breakpoints, I can evaluate variable values real-time as the query executes.
- Highlights syntax errors and upon hover, displays proper syntax with a direct link to the appropriate documentation for the statement in question.
- It would be helpful if one could quickly and easily integrate another editor into this tool. Although the provided editor is quite useful, other 3rd-party editors are much more powerful.
- SQL Developer should be able to easily integrate with source control providers other than GIT and Subversion.
- The syntactical auto-completion should allow some keystroke to complete and suggested statement rather than requiring a mouse-click to accept the suggestion.
- SQL Developer has proven itself invaluable in the development of more than 100 sophisticated reports for our end-users.
- Without SQL Developer, we would have to purchase some other tool for developing and executing queries against our Oracle data.
SQL Developer is the primary tool we use to develop queries for our Jaspersoft reports. It integrates seamlessly with the tools in our environment making it the logical tool for our applications.