Oracle SQL Developer is a graphical user interface that allows the users to browse database objects, run SQL statements and scripts in addition to creating, editing, and debugging PL/SQL statements in the most efficient way. In essence, Oracle SQL Developer enhances productivity and simplifies database development tasks.
Oracle developers will learn how to design and develop databases using this feature-rich, powerful user-extensible interface. They will also learn about the new powerful Data Modeling tool – Oracle SQL Developer Data Modeler. Users can also monitor and manage Application Express applications by integrating with SQL Developer.
Readers will learn to build complex queries based on a number of tables using visual Query Builder, management of PL/SQL code and explore some useful features available to facilitate writing PL/SQL code. They will also learn to integrate the SQL Developer with open source version control systems CVS and Subversion, which allows checking out of files from a repository, editing, and checking them back in.
With easy step-by-step instructions, this book is ideal for all Oracle SQL developers. The book is out now and is available from Packt. For more information, please visit www.packtpub.com/oracle-sql-developer-2-1/book