Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Arrow up icon
GO TO TOP
Oracle SQL Developer 2.1

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

Arrow left icon
Product type Paperback
Published in Dec 2009
Publisher Packt
ISBN-13 9781847196262
Length 496 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Susan Harper Susan Harper
Author Profile Icon Susan Harper
Susan Harper
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

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

Summary


In this chapter, you have had an insight into the features offered by SQL Developer Data Modeler. The Data Modeler provides a number of graphical and textual modeling tools for Logical, Relational, and Multidimensional models. We looked at how to create Logical and Relational models, and how you can import models form the data dictionary or create models from scratch. We looked at forward and reverse engineering, how to build a physical model, and generate the DDL.

The subject of data modeling is vast, and this chapter only introduced some of the many and varied features available in SQL Developer Data Modeler. Whether you are a data architect, or updating an existing design, you can use SQL Developer Data Modeler for building full Entity Relationship Diagram or update schema models and generate the DDL scripts.

In the next chapter, we'll discuss SQL Developer's extensible framework, and look at how you can create user-defined extensions, using XML with embedded SQL and PL/SQL to add...

lock icon The rest of the chapter is locked
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle SQL Developer 2.1
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Modal Close icon
Modal Close icon