Suvarna Garge (Editor)

Oracle SQL Developer

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit
Developer(s)
  
Oracle Corporation

Operating system
  
Cross-platform

Written in
  
Java

Oracle SQL Developer

Stable release
  
4.1.5.21.78 (September 16, 2016; 6 months ago (2016-09-16)) [±]

Type
  
SQL Integrated development environment

License
  
Proprietary OTN SQL Developer License

Oracle SQL Developer (internally often: "sqldeveloper") is an Integrated development environment (IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.

Contents

Features

Oracle SQL Developer supports Oracle products and a variety of third-party plugins which users may deploy to connect to non-Oracle databases. Oracle SQL Developer works with IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase Adaptive Server, Amazon Redshift and Teradata databases.

Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for PL/SQL.

Components

Oracle SQL Developer product components include:

  • OWA (Oracle Web Agent or MOD_PLSQL), is an extension module for the Apache web server, and helps in setting up dynamic web-pages from PL/SQL within Oracle SQL Developer.

    • Extensions

    In addition to the extensions provided by Oracle, third parties have written extensions to add new features to SQL Developer and to integrate with other products:

    New features
  • GeoRaptor, Geospatial data viewer
  • Insider, Collect statistics for a single Oracle instance and display in real time
  • Schema Visualizer allows you to create fully featured Entity Relationship Diagrams (ERD)
    • Integration with other Oracle products
  • SQL Developer Data Modeler operates with and models metadata. Prior to SQL Developer version 3, it constituted a separate (but integrated) free counterpart of SQL Developer. As of SQL Developer version 3 modeling became an integrated part of the overall tool. "Data Modeler" can produce (among other outputs) .dmd files.
    • Integration with other commercial products
  • Red Gate - Deployment Suite for Oracle (Compares schemas and data; deploys all changes.)
  • JDBCWizard (produces Java Web Service code to run your existing PL/SQL and SQL statements)
  • Hotsos Profiler
  • Digger (trace analyzer)
  • SVCO Extension (integrated version-control for Oracle database server schema objects)

    • References

    Oracle SQL Developer Wikipedia
    (Text) CC BY-SA