Packt+ | Advance your knowledge in tech

You're reading from Oracle SQL Developer 2.1 Design and Develop Databases using Oracle SQL Developer and its feature-rich, powerful user-extensible interface with this book and eBook

Product type Paperback

Published in Dec 2009

Publisher Packt

ISBN-13 9781847196262

Length 496 pages

Edition 1st Edition

Languages

SQL

Tools

Oracle Database

Concepts

Database Programming

Author (1):

Susan Harper

View More author details

Table of Contents (19) Chapters

Oracle SQL Developer 2.1

Credits

About the Author

1. Acknowledgement

About the Reviewers

2. Preface

1. Getting Started with SQL Developer FREE CHAPTER

2. Browsing and Editing Database Objects and Data

3. Working with the SQL Worksheet

4. The Power of SQL Reports

5. Working with PL/SQL

6. SQL and PL/SQL Tuning Tools

7. Managing Files

8. Importing, Exporting, and Working with Data

9. Database Connections and JDBC Drivers

10. Introducing SQL Developer Data Modeler

11. Extending SQL Developer

12. Working with Application Express

13. Working with SQL Developer Migrations

Getting started

SQL Developer Data Modeler is an independent product, and with the exception of the Data Modeler Viewer extension to SQL Developer 2.1, is not packaged with other Oracle tools. You can download it and install it in a directory of your choice, with no impact on other tools. To install, simply unzip the file.

Installing and setting up the environment

Getting started with SQL Developer Data Modeler is straightforward. Follow the links from the Data Modeler site on OTN, http://www.oracle.com/technology/products/database/datamodeler to the download location. You are offered a choice of files to download:

For Microsoft Windows, a ZIP file with or without the JRE included
For the Mac OS X, a ZIP file without the JRE included
For Linux, a ZIP file without the JRE included

For any of these ZIP files, extract the file contents and run the datamodeler.exe, which is in the top-level /datamodeler folder, or in the /datamodeler/bin folder. For Linux, use the datamodeler.sh executable.

If the...