Sql Developer Help Center
Sign in
  • BLOG
  • Editor's Picks
  • |
  • Technology
  • |
  • Entrepreneurship
  • |
  • Business
  • |
  • Finance
  • |
  • Career
  • |
  • New India
  • |
  • Entertainment
  • |
  • Others

    • Sql Developer Help Center

    Mrityunjay Kumar

    Software Engineer
    SQL Developer is a database administration and query tool that provides a single consistent interface for various databases.

    Visually navigate through your database structure, create and execute SQL queries and scripts the easy way. Or reverse engineer complete data models with the integrated diagram editor.


    Major features of SQL Developer

    This page shows the major features of SQL Developer at a glance. To get a more detailed overview please visit the screenshots section here.

    Cross Database

    You can connect to every database supporting JDBC access. Additionally ODBC support is provided by the JDBC-ODBC bridge.

    The follwing databases have been tested during development: Oracle 8/8i/9i/10g, IBM DB2 (OS 390, Windows), Sybase Adaptive Server Anywhere, Microsoft SQL Server, Microsoft Access, Microsoft Excel, PostgreSQL, PointBase Server, Firebird, MySQL, Mimer SQL, Gupta SQL Base, Ingres, Informix, Mckoi, Cloudscape and HypersonicSQL.

    Cross Platform

    SQL Developer is written completely in Java. It can be run on every platform supporting Java 1.4 or higher.

    Multi Language User Interface

    SQL Developer comes with English and German UI.

    Full Unicode Support

    Unicode is supported for queries, scripts, data retrieval and file I/O.

    Multiple Connections

    Open multiple connections simultaneously to various databases.

    Dynamic Driver Loading

    Database drivers can be assigned on the fly.

    Dockable Windows

    Arrange your workbench components as you like it by using Drag and Drop!

    Bookmarks

    Manage your frequently used statements with the integrated bookmark repository and the statement history.

    Syntax Highlighting

    Adaptive syntax highlighting for the different SQL dialects supports you while coding.

    Code Completion

    Keyword lookup in the editor gives you access to the complete set of keywords for the active database connection.

    Script Processing

    Long SQL scripts can be run against any database.

    Diagram Editor

    Use the Diagram Editor to visualize tables, views and their relations and dependencies.

    Data Copy & Paste

    Copy data from your spreadsheet application and paste it directly into a database table.

    Data Export

    Export your data as SQL Script, as XML or in CSV format.

    Printing

    Printing support in all source and diagram editors.
    start_blog_img