Top Qs
Timeline
Chat
Perspective
Oracle SQL Developer
Free SQL IDE from Oracle Corporation From Wikipedia, the free encyclopedia
Remove ads
Oracle SQL Developer 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.
Remove ads
Features
Oracle SQL Developer supports Oracle products. In the past a variety of third-party plugins were supported which users were able to deploy to connect to non-Oracle databases. Oracle SQL Developer worked with IBM Db2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase Adaptive Server, Amazon Redshift and Teradata databases.[4]
Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for PL/SQL.
Future versions of Oracle SQL Developer will use Visual Studio Code.[1]
Remove ads
Components
Oracle SQL Developer product components include the OWA (Oracle Web Agent or MOD_PLSQL), an extension module for the Apache web server, and helps in setting up dynamic web-pages from PL/SQL within Oracle SQL Developer.[5]
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:[6]
- Integration with other Oracle products
- SQL Developer Data Modeler operates with and models metadata.[7] Prior to SQL Developer version 3, it constituted a separate (but integrated) free[8] 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.[9]
- Data Miner[10]
History
Remove ads
See also
References
Bibliography
External links
Wikiwand - on
Seamless Wikipedia browsing. On steroids.
Remove ads