Book Image

Oracle SQL Developer 2.1

By : Susan Harper
Book Image

Oracle SQL Developer 2.1

By: Susan Harper

Overview of this book

As technology rapidly evolves, many developers are looking for valuable tools to assist them with their daily tasks. When dealing with databases, a clean, easy-to-navigate interface for working and browsing is essential. Oracle SQL Developer is a graphical user interface that makes life much easier by allowing you to browse database objects, run SQL statements and scripts, and create, edit, and debug PL/SQL statements in the most efficient way. It enhances productivity and simplifies your database development tasks. Although the SQL Developer journey looks simple and easy, there are many areas that can go undiscovered, leaving you just scratching the surface. It's easy to get started and master this powerful tool with this book to hand. It will provide you with in-depth details about all aspects of using SQL Developer to assist you in your day-to-day database tasks and activities. You will learn to utilize SQL Developer's extensible environment to support your ongoing needs This book offers detailed instructions for installing, configuring, and effectively using Oracle SQL Developer. You will learn how to utilize every feature of this development tool and make the most out of it. While none of the tasks are complex, the book progresses from the easy, most commonly used features, such as browsing objects and writing queries in the SQL Worksheet, to the more involved and possibly less frequently used features, such as Tuning and Testing SQL and PL/SQL, and adding User Extensions, and finally to those features used by a smaller more targeted audience, such as Migrations, Oracle APEX, and the Data Modeler. Throughout the book there are tips and suggestions gathered as a result of working with the current SQL Developer user base. This book will also show you how to assess the health of your database with built-in as well as customized reports. By the end of the book you will be confident in making the best use of SQL Developer, and be able to set up and maintain a productive environment for quick and easy database development.
Table of Contents (19 chapters)
Oracle SQL Developer 2.1
Credits
About the Author
Acknowledgement
About the Reviewers
Preface
12
Working with Application Express

Acknowledgement

I'd like to thank the people who have helped me complete this book. In particular Barry McGillin, who reviewed each chapter for technical errors, and Michael Wickham, who joined Barry, to add his technical insight when my writing became more sporadic and the chapters backed up! The editorial staff and publishing team at Packt who patiently accepted each new delay to the schedule, while gently reminding me of the ever-encroaching deadlines.

I'd like to thank my friends who patiently listened each time I said I couldn't go out, "because I was writing…" even those in different countries who were also on the receiving end of my tales that life had become seven-days SQL Developer!

I wasn't planning on writing a book. Working with the product, the team, and customers keeps me busy enough, but there seemed to be more demand for a source of answers to the many questions that bubble up to the surface from forums and events, that it seemed a good thing to do. Believe it or not, I enjoyed it. This would not have been possible without the support of my team, which I am very happy to be a part of. Despite the distances, we are in regular contact, whether chatting to team members in Ireland or Northern Ireland, India or Bulgaria, or in any of the various States of America. We know that we can pick up the phone or dash off a quick instant messenger note and have a chat or ask a question. In particular, I'd like to thank my manager, Kris Rice, and Mike Hichwa who runs the group. Without their guidance and support, the team wouldn't work the way it does, a rare gift when managing a remote and culturally disparate group. Kris in particular, who has his hands full helping me keep things in perspective and constantly tries to help me maintain the balance.