SQL Developer
| Oracle SQL Developer | |
|---|---|
| Basic data
|
|
| developer | Oracle |
| Publishing year | March 2006 |
| Current version |
19.2.1.247.2212 ( September 12, 2019 ) |
| operating system | Windows , Linux , macOS |
| programming language | Java |
| category | SQL development environment |
| License | Freeware |
| German speaking | Yes |
| Product website (Oracle) | |
The SQL Developer is a development environment (IDE) from Oracle for SQL, PL / SQL and an administration tool for databases . The SQL Developer is based on Java and therefore requires a Java runtime environment , but can therefore also run on several platforms. The SQL Developer was originally called "Project Raptor".
Official support only extends to Oracle databases (version 10g or higher) and Microsoft Access , but the Java-based architecture means that JDBC drivers from other databases such as MySQL can also be integrated, although various Oracle-specific functions are not available there to disposal.
Functions
SQL
With the SQL Developer, like any SQL client, SQL queries can be sent to a database.
View, create and edit database objects
For many types of database objects there are forms in the graphical user interface for easy viewing and changing. For example, sequences or table definitions can be created, changed or deleted without knowledge of SQL. Data in tables can be changed, deleted or added directly in the interface. If a table is called, the SQL Developer loads only part of its default settings (e.g. 50 rows) in order to avoid waiting times that are too long, even with large tables. The data displayed in table form can be sorted and filtered.
performance
With the performance functions of the Oracle databases, both a trace and an execution plan can be created in the interface for an SQL statement. With this information it is possible for specialists to optimize the SQL statements or to identify problematic areas.
Import / export
The software also includes many options for exporting and importing data. The structure of database objects can be exported in DDL statements. The content of tables can be saved in HTML pages, CSV or Excel files , for example , or SQL (insert statements) can be generated from them. Data can be imported from CSV and Excel files.
PL / SQL
Furthermore, the SQL Developer offers the possibility of developing functions and procedures in the PL / SQL programming language that can be executed directly in Oracle databases . In addition to an editor with syntax highlighting, a debugger is also available for this. This accesses the debugging options of the Oracle database. From version 2.1 onwards, unit tests for PL / SQL programs can also be created.
links
Connections to various databases can be managed in one window. Connections to different databases can be used at the same time. Connections are created and saved with the usual information (user, password, etc.). From then on, they are also available after a restart. Once a connection has been established, the database objects of the respective database are listed in a tree structure, sorted by type.
migration
Functions are available for migrating from other DBMS (Sybase, Microsoft SQL Server and Access) to Oracle.
Availability
The SQL Developer is freely available (after registration) and thus offers an alternative to fee-based SQL clients such as TOAD .
See also
Web links
- Product homepage on oracle.com
- Page about the SQL developer in the Wikibook Oracle