20.5 Managing Oracle Databases with Oracle SQL Developer
Developers working with Microsoft’s SQL Server have become very dependent on graphical tools like SQL Server Manager Studio. These tools boost developers’ productivity by enabling them to manage databases, run SQL scripts, and much more, all within a single powerful interface.
Oracle SQL Developer, formerly Project Raptor, brings that same power to developers working with Oracle databases. It allows you to browse, create, and edit database objects, run SQL statements and scripts, run and debug PL/SQL, view and create reports, and more.
OracleSQL Developer at a Glance | |
---|---|
Tool | Oracle SQL Developer |
Version covered | 1.0.0.15 |
Home page | http://www.oracle.com/technology/products/database/sql_developer/index.html |
Power Tools page | |
Summary | Free graphical PL/SQL IDE for database development |
License type | Oracle Technology Network (OTN) License Agreement; no export to countries prohibited by the U.S. |
Online resources | Forum, FAQs, tutorials |
Supported Frameworks | Sun J2SE 1.5.0_05 for Windows |
Related tools in this book | Oracle Developer Tools for Visual Studio .NET |
Getting Started
Oracle SQL Developer is built on Java and the same IDE platform as JDeveloper, so it is portable, platform-independent, and mature for its age. It is currently available for Windows, Linux/Unix, and Mac OS X. Oracle SQL Developer requires Java’s 1.5.0.05 ...
Get Windows Developer Power Tools now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.