Great Software for Creating, Running, and Debugging SQL Scripts
March 15, 2017

Great Software for Creating, Running, and Debugging SQL Scripts

Robby Tabuchi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with SQL Developer

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.
  • This software allows multiple users to accomplish input and output of large amounts of data.
  • When learning to create sql scripts, SQL Developer is a great real time tool for training.
  • Both the Information Service and Prospect Development team is able to quickly access and verify important info to pass along to our Development team and leadership to make business decisions.
  • The softwares enables myself and a data analyst to have control of the data output for complex analytics.
  • notepad++
I write SQL scripts in notepad++ due to ease of access and saving capabilities but I could certainly do the same in SQL Developer. I encourage the rest of my team in prospect development to customize my scripts in SQL Developer so that they are not saving over files that I have in production.
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.