Item: Oracle SQL Developer
Rating: 7
Author: Verified User

Use Cases and Deployment Scope

Oracle SQL Developer is used across the company by different users depending on their preferences. Since it’s free, anyone can download and use it. It is best SQL editor for Oracle and other databases--lots of features and easy to use. It’s reliable and performs better than other similar tools. It helps database users to query, manage data in large enterprise databases like Oracle and Teradata. Oracle SQL Developer also has features for database migration, data modeling, data mining, import/export, versioning, analytics reports, change management, debugging, and logging.

Pros and Cons

Database querying SQL
Data modeling and design
Database explorer
Data filtering, export/import
Database object management
Data migration
Debugging
Version control
OLAP
Analytics reports
Sessions
Database comparision

Better user interface
Native support for other databases
Autocompletion
Performance

Return on Investment

It’s completely free
Improved developers for better efficiency
Can save time on querying and data modeling
Better data management
No need to have multiple tools for each database

Alternatives Considered

Toad for Oracle

Oracle SQL Developer is neck and neck with other tools. It offers all the required features and is much more reliable than many other vendors. Since it’s developed by Oracle, it works well with Oracle. It’s ultimately down to individual selection but Oracle SQL Developer offers a lot of features and it’s hard to think about other tools.

Key Insights

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?

Yes

Did implementation of Oracle SQL Developer go as expected?

Yes

Would you buy Oracle SQL Developer again?

Yes

Other Software Used

Tableau Desktop, Alteryx, PyCharm, Teradata Data Warehouse Appliance 2850, ThoughtSpot, Microsoft Visual Studio Code

Likelihood to Recommend

It’s best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc.

It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.