Likelihood to Recommend
The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Oracle SQL Developer is ideal for everyday common database CRUD operations. It is also helpful in formatting SQL queries into Java code and vice versa.
- Crunches huge datasets
- Has versatility in functionality and grouping capabilities
- Native XML macro language is easy to master
- The platform has great visualization tools
- 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.
- Inconsistency and data incompatibility in date and time syntax, string concatenation and is case sensitivity.
- Reconnect menu item does not always work when the database has been unexpectedly disconnected
- Not stable when query is taking long time to execute
- When reconnected to DB, the previous SQL query window could have been opened instead of opening new query window
While we have used SQL, 1010data is really the only industry standard product available for our use.
Initially I selected SQL Developer, as it was easy to query the database, to export the results and DBA privileges. But later due to some disadvantages of SQL developer (not responsive, query window hangs suddenly) worked on Also worked on other tools like Toad, MySQL to query the database so that, the disadvantages can be overcome.Also, worked on PL/SQL Developer to query the database which has procedures / functions by connecting to different schemas.
Return on Investment
- This has sped up the process of analysis.
- We can now automate process which were performed manually.
- Analysis can be performed more frequently.
Premium Consulting/Integration Services—
Entry-level set up fee?