If you were talking to someone whose organization is considering Oracle SQL Developer, what would you say?
How would you rate it and why? Any other tips or advice?
In terms of advice, I would first ask you what you are expecting from the tool and, if it is in the scope of Oracle SQL Developer, I would recommend it. I rate this solution at nine out of 10. It accomplishes what I expect. It's a nine and not a 10 because, it needs better real-time monitoring of development.
Try this if you do not need a lot of storage, especially since it is free and if it is the newer version with no GUI version. Everybody should try it because you do not have to code things to create output from JSON or DDL. It allows you to get everything you want together: tables, indexes, etc.
I think it's a good product in the sense that it does not overwhelm you with many features. So I would give it a 10 out of 10. I would recommend it.
When selecting a vendor the most important criterion is that they are professional. I rate this solution at six out of 10 because there are better tools that I am using. One of them is Toad, from Quest Software. Toad is more intuitive, easier to use, doing better work, and has more features. I prefer Toad. But if it is a question of budget, it's better to use SQL Developer.
Just try it. It's very easy.
Using this solution depends on budget and on the number of developers. The more developers you have, the less you will want SQL Developer.
I think you should make yourself familiar with this product and get into the core functionality first, before making a decision. I would rate it a nine out of 10 because I like its features, how well it is integrated into the core Oracle Database, and it's the first choice when you have to do stuff within the database.