Oracle SQL Developer - Free Rool
Updated December 21, 2023
Oracle SQL Developer - Free Rool
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle SQL Developer
We utilize SQL Developer as the IDE tool to connect to the Oracle Database, although we don't employ all of its functionalities. Our primary use of this tool is to retrieve SQL queries and debug packages. The entire object structure is managed in a GitLab repository, and all scripts are executed using VS Code.
- Structure Oracle Database objects
- Intuitive navigation
- Export Data
- Java dependency
- Autocomplete issues
- The only positive impact is that is free
- It's hard to get used it when you worked with TOAD or PL/Developer for years before.
They do almost the same things, but I particularly I prefer TOAD, maybe because when I started programming with Oracle Database it was the first tool that I used and I think it's easier to use too.
Do you think Oracle SQL Developer delivers good value for the price?
Yes
Are you happy with Oracle SQL Developer's feature set?
Yes
Did Oracle SQL Developer live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of Oracle SQL Developer go as expected?
Yes
Would you buy Oracle SQL Developer again?
Yes
Using Oracle SQL Developer
5 - We're a team of five developers, including the boss who manages all the schemas. We typically use SQL Developer to browse objects, retrieve and export data, and for debugging PL/SQL blocks. Additionally, it's convenient for maintaining and saving all schema passwords in one place. We can even export the connection properties.
5 - Currently, our team consists of 5 members. While I hold some Oracle certifications, two members of my team are particularly experienced users without any certifications. However, the majority of the scripting or managing tasks is performed using scripts that we run on VS Code. We are proactive in keeping up with the latest versions, and we specifically choose Oracle SQL Developer because it is developed by Oracle itself, ensuring reliability as it is not third-party software.
- Querying and Data Retrieval
- PL/SQL Development and Debugging
- Database Object Browsing and Management
- We're going to continue using it as we are right now
Evaluating SQL Developer and Competitors
- Ease of Use
- Other
Oracle SQL Developer is not a software that we purchase, it is free.
I don't believe we would change anything. As usual, we seek insights from industry experts and incorporate a comprehensive cost-benefit analysis.
SQL Developer Implementation
- Implemented in-house
Not sure - We've been using SQL Developer for over 10 years, and there hasn't been any organizational change management implemented thus far that has affected our use of Oracle SQL Developer.
SQL Developer Support
| Pros | Cons |
|---|---|
Quick Resolution Knowledgeable team Kept well informed Immediate help available Support cares about my success | Poor followup Problems left unsolved Escalation required Need to explain problems multiple times Slow Initial Response |
I have never contacted support for this product.
I don't recall ever contacting Oracle support for this product. Typically, I am someone who likes to report issues, but I don't remember doing so. Most of the time, I visit the forum, and someone from Oracle usually answers my questions, which is generally satisfactory. I have no complaints.
Using SQL Developer
| Pros | Cons |
|---|---|
Like to use Relatively simple Easy to use Technical support not required Well integrated Consistent Quick to learn Convenient Feel confident using Familiar | None |
- DBMS_OUTPUT
- Export Data
- Import Data
- Create Objects
- Explain Plain
- SQL Tuning Advisor