Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Verified User
Employee in Information Technology (5001-10,000 employees employees)
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
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
Alternatives Considered
Microsoft SQL Server and MySQL
Other Software Used
TIBCO ActiveSpaces, TIBCO BusinessEvents, Postman, SoapUI Open Source, supported by SmartBear, Notepad++, Microsoft Visual Studio Code, Eclipse
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Senior Application Engineer in Information Technology at STMicroelectronics (10,001+ employees employees)
Use Cases and Deployment Scope
I use Oracle SQL Developer as an editor to run various queries and export data to my desired format as Excel or CSV files. I usually use it on Windows, but it could be used on other operating systems, so it is a great advantage for me when I change platforms.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Lead Database Administrator in Information Technology at Concentrix Corporation (10,001+ employees employees)
Pros
Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
Cons
Showing more detail on real-time database performance data
Integration with AWR report
Show more diagnostic info on Oracle RAC
Return on Investment
It's a free product with all the feature developer need to do their job
Huge saving compare to other licensed product
Increase the productive on application development
Alternatives Considered
Oracle Enterprise Manager
Other Software Used
Percona Server for MySQL, PostgreSQL, Neo4j
Related Products
Products similar to Oracle SQL Developer that may also meet your needs.
