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

Overall Satisfaction with Oracle SQL Developer

Use Cases and Deployment Scope

We are using Oracle in integration with TIBCO AMX BPM to store data for managing users, update KYC details, store daily operations data etc. Oracle SQL Developer provides a solid graphical user interface to view and update data. It is easy to segregate data using schema names in Oracle SQL Developer. Both developers and administrators are using Oracle SQL Developer as it is easy to learn and use. We have created tables, views, stored procedures and indexes using Oracle SQL Developer.

Pros and Cons

Pros

Easy to create stored procedure
Easy data management using GUI
IntelliSense for guiding query building
Support for multiple schemas within single connection

Cons

Might not be suitable for Production environment
Scaling is limited
Can be difficult to operate for beginners

Return on Investment

Oracle SQL Developer is available for download for free, saving license costs
Supports development and management of data stored On-Prem and data stored on Cloud as well
Easy to integrate with reporting tools providing a deep dive into data and leads to faster analysis and decision making

Usability

Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer.

Alternatives Considered

Microsoft SQL Server and MySQL

Oracle SQL Developer is easy to install, easy to use and navigate and feature rich graphical user interface to view and manage data. It can be used across various roles like developer, tester, administrator etc. It helps to develop a strong base for database understanding. There are a lot of tools available for performing multiple operations on data and IntelliSense feature enables guided support for creating queries.

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

TIBCO ActiveSpaces, TIBCO BusinessEvents, Postman, SoapUI Open Source, supported by SmartBear, Notepad++, Microsoft Visual Studio Code, Eclipse

Likelihood to Recommend

Oracle SQL Developer helps obtain performance metrics by showing the time taken to run any query or stored procedure. It allows to create indexes on tables for fetching results much faster. We can create sequence which can be configured for auto increase and is useful for numbering the records stored in the tables. Before connecting to any server there is an option to test the credentials which allows verification of credentials without blocking the connection when user is not too sure about the password. It provides support for queues, XML schemas as well

Comments

Please log in to join the conversation

Oracle SQL Developer Review