The SQL Worksheet provides a scratch pad for all SQL, PL/SQL, and SQL*Plus statements and commands. You can run individual statements or a collection of commands. You can also run scripts and execute PL/SQL. In essence, doing all you might do in a command-line interface like SQL*Plus. The SQL Worksheet provides more, in that it offers code templates, provides code snippets, assists with code insight and completion, and maintains a history of commands. In this chapter, we look at these and other features offered in the SQL Worksheet and how to use them. We will use SQL and SQL*Plus commands to illustrate features, using PL/SQL only where needed specifically for a feature. All aspects of PL/SQL are addressed in the chapter on Working with PL/SQL.
Oracle SQL Developer 2.1
By :
Oracle SQL Developer 2.1
By:
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.
Related Content you might be interested in
Current Title:
Oracle SQL Developer 2.1
No titles found
Table of Contents (19 chapters)
Oracle SQL Developer 2.1
Credits
About the Author
Acknowledgement
About the Reviewers
Preface
Free Chapter
Getting Started with SQL Developer
Browsing and Editing Database Objects and Data
Working with the SQL Worksheet
The Power of SQL Reports
Working with PL/SQL
SQL and PL/SQL Tuning Tools
Managing Files
Importing, Exporting, and Working with Data
Database Connections and JDBC Drivers
Introducing SQL Developer Data Modeler
Extending SQL Developer
Working with Application Express
Working with SQL Developer Migrations
Customer Reviews