I recommend users looking to implement Oracle SQL Developer to consider using cloud solutions instead of relying solely on Oracle DB, as the cloud offers better scalability and reduces maintenance downtime. I believe that while initial costs of cloud solutions may be higher, they provide more sustainable benefits for long-term growth. We are using a free version of Oracle SQL Developer, not a paid version. While Visual Studio has a licensed version, there aren't any specific licensing requirements for installing Oracle SQL Developer. We are using the basic, freeware version for connectivity. There may be a paid version with enhanced features, but that is not implemented due to cost-effectiveness at the project level. Data modeling capabilities exist in Oracle SQL Developer, but they are mainly used by DBA teams. They work on data modeling, including entity framework-related tasks. However, we typically refrain from doing those tasks ourselves because DBAs are the best suited for that work. We have integrated version control, specifically TFS, to maintain our database-related aspects. When the table structure changes, we keep track of those changes with unique numbering in TFS, allowing us to monitor who made changes to any database objects. We also append work items in TFS, which maps to the Azure DevOps board, enabling tracking of work item numbers related to changes. We utilize automated SQL tuning features. For instance, we request tuning for some queries, but the initial query is usually written by us. We advise our junior developers to use tuning, especially when they create unnecessarily lengthy and complex queries that could be simplified through straightforward joins. On a scale of 1-10, I rate Oracle SQL Developer an 8 out of 10.
For first-time users of Oracle SQL Developer, it's going to be a bit difficult, but they can find their way around over time. I rate Oracle SQL Developer a nine out of ten. I didn't face any other issues other than it being a bit slow when you have a lot of work to do.
Senior Partner at a manufacturing company with 1-10 employees
Real User
2018-08-21T06:20:00Z
Aug 21, 2018
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.
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.
Senior Database Consultant at Performing Databases
Consultant
2018-01-28T13:15:00Z
Jan 28, 2018
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.
Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.
For more information on...
I recommend users looking to implement Oracle SQL Developer to consider using cloud solutions instead of relying solely on Oracle DB, as the cloud offers better scalability and reduces maintenance downtime. I believe that while initial costs of cloud solutions may be higher, they provide more sustainable benefits for long-term growth. We are using a free version of Oracle SQL Developer, not a paid version. While Visual Studio has a licensed version, there aren't any specific licensing requirements for installing Oracle SQL Developer. We are using the basic, freeware version for connectivity. There may be a paid version with enhanced features, but that is not implemented due to cost-effectiveness at the project level. Data modeling capabilities exist in Oracle SQL Developer, but they are mainly used by DBA teams. They work on data modeling, including entity framework-related tasks. However, we typically refrain from doing those tasks ourselves because DBAs are the best suited for that work. We have integrated version control, specifically TFS, to maintain our database-related aspects. When the table structure changes, we keep track of those changes with unique numbering in TFS, allowing us to monitor who made changes to any database objects. We also append work items in TFS, which maps to the Azure DevOps board, enabling tracking of work item numbers related to changes. We utilize automated SQL tuning features. For instance, we request tuning for some queries, but the initial query is usually written by us. We advise our junior developers to use tuning, especially when they create unnecessarily lengthy and complex queries that could be simplified through straightforward joins. On a scale of 1-10, I rate Oracle SQL Developer an 8 out of 10.
For first-time users of Oracle SQL Developer, it's going to be a bit difficult, but they can find their way around over time. I rate Oracle SQL Developer a nine out of ten. I didn't face any other issues other than it being a bit slow when you have a lot of work to do.
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.