Item: Oracle SQL Developer
Rating: 9
Author: Verified User

Overall Satisfaction with Oracle SQL Developer

Use Cases and Deployment Scope

Oracle SQL Developer is used by our entire organization but in my department, I know we use this daily and pretty heavily. We use SQL Developer to quickly and easily pull data dependent on certain criteria, often there would be no other way to gather this kind of data without the help and database of the Oracle SQL Developer. This functionality serves us with requests from the business side for meter configurations, sample meter tests for the years exchanges, time window accruing Field Activities that need to reapply, and hundreds if not thousands of other functions that apply. Often, there is something brand new to us that we use this tool to help us narrow down what data we are looking for.

Pros and Cons

Pros

Searches for and gathers data quickly and efficiently.
If you error during writing your queries, this usually provides accurate reasons why your query errored, allowing you to quickly make the correct fixes.
Allows for customization.

Cons

I am stretching to come up with cons for SQL Developer, it could possibly have more tips and tricks for easily writing queries. Maybe more user-friendly functionality.

Return on Investment

Quickly and accurately can collect thousands of pieces of data which normally would have been done with spreadsheets and cross-referencing.
The positive impact is that we are able to do collect thousands of rows of data if needed within seconds. Saving a lot of time that can be applied to other areas of concern in everyday business processes.

Alternatives Considered

Toad Data Point

Prior to using Oracle SQL Developer, I used Toad Data Point. I did not have any decision making in choosing Oracle SQL over Toad Data Point but I can say the ease of use is noticeable in Oracles SQL. Oracle is every bit as good if not better than Toad Data Point due to ease of transition, working flawlessly with our database, and user assistance built-in.

Key Insights

Do you think Oracle SQL Developer delivers good value for the price?

Yes

Are you happy with Oracle SQL Developer's feature set?

Yes

Did Oracle SQL Developer live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Oracle SQL Developer go as expected?

Yes

Would you buy Oracle SQL Developer again?

Yes

Other Software Used

Oracle Utilities Meter Data Management (MDM)

Likelihood to Recommend

Oracle SQL Developer is best suited anytime data is requested or we need to investigate an issue. Often, everything you might be looking for is not found on the same table, so joining tables to pull all of the information you might need or want is a very helpful tool. Doing this and branching out with your query writing skills takes time but this is where SQL is best suited. You will see while you're doing this that it may prompt you to help you more easily connect the tables.

Comments

Please log in to join the conversation

Oracle SQL Developer paves the way