更新时间:2021-04-01 13:27:03
Coverpage
Copyright Information
Credits
About the Author
Acknowledgement
About the Reviewers
Preface
What this book covers
Standards and assumptions
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started with SQL Developer
Preparing your environment
A quick overview
Navigating around SQL Developer
Finding more help
Summary
Chapter 2. Browsing and Editing Database Objects and Data
Browsing objects
Creating and updating database objects
Chapter 3. Working with the SQL Worksheet
Introducing the SQL Worksheet
Writing and executing commands
Using the Query Builder
Chapter 4. The Power of SQL Reports
Introducing SQL Developer reports
Browsing shipped reports
Creating your own reports
Sharing reports
Chapter 5. Working with PL/SQL
Creating PL/SQL code
Creating and compiling PL/SQL program units
Editing code
Debugging PL/SQL
Chapter 6. SQL and PL/SQL Tuning Tools
Support for tuning code in the SQL Worksheet
Additional performance tuning tools
Profiling PL/SQL
Chapter 7. Managing Files
Introducing source code control
Getting started
Working with files under version control
Chapter 8. Importing Exporting and Working with Data
Exporting data
Importing data
Using the Database Copy wizard
Comparing schemas
Chapter 9. Database Connections and JDBC Drivers
Working with Oracle connections
Creating non-Oracle database connections
Chapter 10. Introducing SQL Developer Data Modeler
Oracle SQL Developer Data Modeler
Working with diagrams and their components
Analysis design and generation
Integration with Oracle SQL Developer
Chapter 11. Extending SQL Developer
Introducing extensibility
SQL Developer XML extension types
Reviewing an example
Working with extensions
Chapter 12. Working with Application Express
Setting the scene
Chapter 13. Working with SQL Developer Migrations
Introducing SQL Developer Migrations
Setting up your environment
Migrating
Additional migration activities
Index