What users are saying about

1010data

5 Ratings

SQL Developer

94 Ratings

1010data

5 Ratings
Score 5.2 out of 101

SQL Developer

94 Ratings
Score 8.3 out of 101

Add comparison

Likelihood to Recommend

1010data

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

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.

Pros

  • 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.

Cons

  • The ten.do interface could use more detailed documentation
  • 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.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
No score
No answers yet
No answers on this topic

Alternatives Considered

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

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

SQL Developer

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
Additional Pricing Details