What is Oracle SQL Developer?

Oracle SQL Developer serves as a dynamic and user-friendly development environment that simplifies the tasks of both developing and overseeing Oracle Database, applicable in both conventional environments and cloud-based solutions. It encompasses extensive features that support the entire PL/SQL application development lifecycle, including a worksheet for running queries and scripts, along with a DBA console that aids in efficient database administration. Furthermore, the tool provides a reporting interface, a robust data modeling solution, and a means to migrate third-party databases into Oracle. Users are empowered to execute SQL commands, manage user accounts, create or modify database objects, import data into tables, troubleshoot performance issues, visualize database schemas, and much more. This comprehensive tool integrates the functionalities of a powerful desktop application right within a web browser. In addition, with the support of Oracle REST Data Services, users can easily connect to their on-premises database instances, and the platform also streamlines the transition from Oracle On-Premises to Oracle Cloud, enhancing the interaction and management of database content. By facilitating database development and management at any time and from nearly any location, this tool significantly boosts overall productivity for users. Its accessibility and functionality make it an essential resource for database professionals.

Screenshots and Video

Oracle SQL Developer Screenshot 1

Company Facts

Company Name:
Oracle
Date Founded:
1977
Company Location:
United States
Company Website:
www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html

Product Details

Deployment
Windows
Mac
Linux
On-Prem
Training Options
Documentation Hub
Online Training
Webinars
On-Site Training
Support
Standard Support
24 Hour Support
Web-Based Support

Product Details

Target Company Sizes
Individual
1-10
11-50
51-200
201-500
501-1000
1001-5000
5001-10000
10001+
Target Organization Types
Mid Size Business
Small Business
Enterprise
Freelance
Nonprofit
Government
Startup
Supported Languages
English

Oracle SQL Developer Categories and Features

IDE Software

Code Completion
Compiler
Cross Platform Support
Debugger
Drag and Drop UI
Integrations and Plugins
Multi Language Support
Project Management
Text Editor / Code Editor

Database Software

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

Oracle SQL Developer Customer Reviews

Write a Review
  • Reviewer Name: Stefan L.
    Position: Consultant
    Has used product for: 2+ Years
    Uses the product: Daily
    Org Size (# of Employees): 1,000 - 4,999
    Feature Set
    Layout
    Ease Of Use
    Cost
    Customer Service
    Would you Recommend to Others?
    1 2 3 4 5 6 7 8 9 10

    Capable SQL coding environment

    Date: Jun 09 2021
    Summary

    Being a daily driver for SQL queries, SQL Developer runs well and reliable for daily querying purposes. Being able to store often used queries, recall them and export results reliable is really useful. However, all this requires a lot of mouse-clicks. Some automation/templating would be helpful. Note: cancelling running queries may require restarting the program

    Positive

    -simple layout (focus on history, connections and SQL query tabs
    -reliable performance
    -supports JDBC connections
    -export options work well

    Negative

    -cannot cancel running queries effectively
    -amount of commands in menu structure can be daunting
    -export could be better (use of templates and pre-selections)

    Read More...
  • Previous
  • You're on page 1
  • Next