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.
SQL Developer is great for keeping multiple Oracle database query sessions open at one time within one application. If I use SQL*Plus, I have to have a terminal server connection open first. So every SQL session is in a different window. That quickly becomes a lot of windows to keep track of. We do not use it for running automated scripts. Those are done through the command line.
Senior Database Administrator
Ivy Tech Community CollegeHigher Education, 5001-10,000 employees
- Crunches huge datasets
- Has versatility in functionality and grouping capabilities
- Native XML macro language is easy to master
- The platform has great visualization tools
- PL/SQL Development: the tool's strength really. SD supports code condensing, parentheses/brace matching, insites (popup windows with data object column names, etc).
- I like the report feature...very easy to add your library of SQL to be run as reports. SD works with bind variables in your SQL well too.
- The history feature is particularly nice. It's called SQL Recall and it saves quite a number of PL/SQL and SQL code you have been working with for near-future reference and recovery if needed.
- The code snippets is very nice. Various functions and function details at your fingertips. Use a drag and drop operation to add to your code.
- SQL Tuning. SD has explained plans but these could easily be improved upon using the latest features of the Oracle RDBMS.
- More code templates. You can add your own but the tool seems to be lacking a bit when it comes to pre-existing code examples.
- Smaller foot print. The thing is huge and somewhat slow.
- Seems every time I get a newer SD, I also have to upgrade the Java environment as well. Would be nice if they picked a rev of Java and stuck to it.
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.
- Positive impacts: Able to connect to multiple schemas simultaneously and query the DB easily to get results
- Many DBA functions can be performed like checking table spaces, currently running jobs and running execution plans for queries
- Results obtained from query execution can be exported easily to desired formats
- Negative impacts: Sometimes when query is taking more time to return results, SQL Developer does not respond
- The Reconnecting menu of SQL Developer does not work always after the database has been unexpectedly disconnected
Premium Consulting/Integration Services—
Entry-level set up fee?