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

http://www.windevpowertools.com/tools/111

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.