Oracle SQL Developer Handbook

by Hotka, Dan

• ISBN13: 9780071484749
• ISBN10: 0071484744
• Edition: 1st
• Format: Paperback
• Copyright: 2006-10-31
• Publisher: McGraw Hill

Summary

Start-to-finish coverage of Oracle's new free development tool, from Oracle Press Here is the first book to offer concise, practical details for installing, setting up, and effectively using Oracle's new free development tool--Oracle SQL Developer. Featuring a Quick Start section and tips and techniques previously not available in print, this Oracle Press guide will help you effectively enhance productivity and simplify database development tasks.

Author Biography

Dan Hotka is a training specialist who has more than 22 years of experience with Oracle products. He is frequently published in Oracle trade journals and regularly speaks at Oracle conferences and user groups around the world.

Table of Contents

Foreword	p. xi
Preface	p. xiii
Acknowledgments	p. xix
Introduction	p. xxi
Getting Started
Product Installation, Upgrades, and System Requirements	p. 3
System Requirements to Include Supported Databases	p. 4
Installation Process	p. 5
Installing and Running SQL Discoverer on Windows	p. 5
Installing and Running SQL Developer on Linux	p. 5
Installing and Running SQL Developer on Mac OS	p. 6
Installing Newer Releases	p. 6
Product Versions	p. 8
Getting Help	p. 9
Join the List Group	p. 9
Summary	p. 10
Getting Connected	p. 11
Working with Connections	p. 12
Establishing New Connections	p. 14
Setting Up Basic Connections	p. 16
Setting Up TNS Connections	p. 16
Setting Up Custom JDBC Connections	p. 16
Connecting to Oracle10g Express	p. 16
Exporting/Importing Your Connections	p. 17
Summary	p. 17
Quick Start	p. 19
Introduction to SQL Developer	p. 20
Establishing a Connection to the Database	p. 23
Navigating SQL Developer	p. 24
Viewing, Changing, and Saving Data	p. 27
Executing SQL	p. 29
Viewing and Saving Output	p. 31
Working with SQL	p. 33
Coding Assistants	p. 34
Using Code Templates	p. 35
Using SQL History	p. 36
Executing SQL Scripts	p. 37
Executing PL/SQL	p. 37
Useful Information from Reports	p. 38
Summary	p. 39
Using SQL Developer
General Information	p. 43
Viewing and Hiding Toolbars	p. 44
Opening and Closing Interfaces	p. 44
Customizing the Display	p. 47
Dockable Windows	p. 48
Pinning Displays	p. 50
Autohide Displays	p. 50
Splitting Tab Displays	p. 50
Preferences	p. 52
Summary	p. 72
Working with the Connections Navigator	p. 73
Working with Objects	p. 74
The Connections Navigator Toolbar	p. 74
Working with Connections	p. 76
Working with Database Objects	p. 78
Summary	p. 113
Working with SQL	p. 115
The SQL Worksheet Interface	p. 116
Entering, Accessing, and Executing SQL	p. 119
Executing PL/SQL	p. 120
Creating SQL without Typing	p. 121
Miscellaneous SQL Topics	p. 127
SQL History	p. 127
SQL Formatting	p. 128
Saving SQL	p. 128
SQL Output	p. 130
Summary	p. 136
Working with PL/SQL	p. 137
The SQL Developer PL/SQL Editor Interface	p. 138
Editing PL/SQL Code	p. 139
Compiling PL/SQL Code	p. 139
Executing Packages, Procedures, and Functions	p. 141
Coding Productivity	p. 143
Using the PL/SQL Debugger	p. 146
Summary	p. 159
Additional Topics	p. 161
Find and Replace Text	p. 162
Using Find and Replace Features	p. 162
Using Incremental Find Forward/Backward	p. 163
Quickly Navigating Around Code	p. 164
Using Bookmarks	p. 164
Using Line Numbers	p. 165
Database Export	p. 166
Summary	p. 169
SQL Developer Reports
Available Reports	p. 173
Running Reports	p. 174
Drillable Reports	p. 178
Data Dictionary Reports	p. 179
About Your Database	p. 180
Database Administration	p. 181
Table	p. 196
PL/SQL	p. 196
Security	p. 197
XML	p. 199
Jobs	p. 200
Streams	p. 200
All Objects	p. 201
Data Dictionary	p. 202
Summary	p. 204
User-Defined Reports	p. 205
Adding Categories	p. 206
Adding Reports	p. 208
Reports with Optional Input Variables	p. 209
Summary	p. 210
Appendixes
Feature, Function, and Keystroke Cross-Reference	p. 213
Keystroke Cross-Reference	p. 214
Feature/Function Cross-Reference	p. 216
Summary	p. 217
SQL Developer Version 1.1 and Beyond	p. 219
SQL Developer Version 1.1	p. 220
General Interface Improvements	p. 220
Object Navigator Improvements	p. 220
SQL Worksheet Improvements	p. 220
Data Grid Improvements	p. 221
PL/SQL Code Editor Improvements	p. 221
Reports Improvements	p. 221
SQL Developer Version 1.2	p. 221
Index	p. 223
Table of Contents provided by Ingram. All Rights Reserved.