+612 9045 4394
Oracle SQL Developer Handbook : Oracle Press - Dan Hotka

Oracle SQL Developer Handbook

Oracle Press

By: Dan Hotka

Paperback Published: 10th October 2006
ISBN: 9780071484749
Number Of Pages: 230

Share This Book:


This title is not in stock at the Booktopia Warehouse and needs to be ordered from our supplier.
Click here to read more about delivery expectations.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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.

Forewordp. xi
Prefacep. xiii
Acknowledgmentsp. xix
Introductionp. xxi
Getting Started
Product Installation, Upgrades, and System Requirementsp. 3
System Requirements to Include Supported Databasesp. 4
Installation Processp. 5
Installing and Running SQL Discoverer on Windowsp. 5
Installing and Running SQL Developer on Linuxp. 5
Installing and Running SQL Developer on Mac OSp. 6
Installing Newer Releasesp. 6
Product Versionsp. 8
Getting Helpp. 9
Join the List Groupp. 9
Summaryp. 10
Getting Connectedp. 11
Working with Connectionsp. 12
Establishing New Connectionsp. 14
Setting Up Basic Connectionsp. 16
Setting Up TNS Connectionsp. 16
Setting Up Custom JDBC Connectionsp. 16
Connecting to Oracle10g Expressp. 16
Exporting/Importing Your Connectionsp. 17
Summaryp. 17
Quick Startp. 19
Introduction to SQL Developerp. 20
Establishing a Connection to the Databasep. 23
Navigating SQL Developerp. 24
Viewing, Changing, and Saving Datap. 27
Executing SQLp. 29
Viewing and Saving Outputp. 31
Working with SQLp. 33
Coding Assistantsp. 34
Using Code Templatesp. 35
Using SQL Historyp. 36
Executing SQL Scriptsp. 37
Executing PL/SQLp. 37
Useful Information from Reportsp. 38
Summaryp. 39
Using SQL Developer
General Informationp. 43
Viewing and Hiding Toolbarsp. 44
Opening and Closing Interfacesp. 44
Customizing the Displayp. 47
Dockable Windowsp. 48
Pinning Displaysp. 50
Autohide Displaysp. 50
Splitting Tab Displaysp. 50
Preferencesp. 52
Summaryp. 72
Working with the Connections Navigatorp. 73
Working with Objectsp. 74
The Connections Navigator Toolbarp. 74
Working with Connectionsp. 76
Working with Database Objectsp. 78
Summaryp. 113
Working with SQLp. 115
The SQL Worksheet Interfacep. 116
Entering, Accessing, and Executing SQLp. 119
Executing PL/SQLp. 120
Creating SQL without Typingp. 121
Miscellaneous SQL Topicsp. 127
SQL Historyp. 127
SQL Formattingp. 128
Saving SQLp. 128
SQL Outputp. 130
Summaryp. 136
Working with PL/SQLp. 137
The SQL Developer PL/SQL Editor Interfacep. 138
Editing PL/SQL Codep. 139
Compiling PL/SQL Codep. 139
Executing Packages, Procedures, and Functionsp. 141
Coding Productivityp. 143
Using the PL/SQL Debuggerp. 146
Summaryp. 159
Additional Topicsp. 161
Find and Replace Textp. 162
Using Find and Replace Featuresp. 162
Using Incremental Find Forward/Backwardp. 163
Quickly Navigating Around Codep. 164
Using Bookmarksp. 164
Using Line Numbersp. 165
Database Exportp. 166
Summaryp. 169
SQL Developer Reports
Available Reportsp. 173
Running Reportsp. 174
Drillable Reportsp. 178
Data Dictionary Reportsp. 179
About Your Databasep. 180
Database Administrationp. 181
Tablep. 196
PL/SQLp. 196
Securityp. 197
XMLp. 199
Jobsp. 200
Streamsp. 200
All Objectsp. 201
Data Dictionaryp. 202
Summaryp. 204
User-Defined Reportsp. 205
Adding Categoriesp. 206
Adding Reportsp. 208
Reports with Optional Input Variablesp. 209
Summaryp. 210
Feature, Function, and Keystroke Cross-Referencep. 213
Keystroke Cross-Referencep. 214
Feature/Function Cross-Referencep. 216
Summaryp. 217
SQL Developer Version 1.1 and Beyondp. 219
SQL Developer Version 1.1p. 220
General Interface Improvementsp. 220
Object Navigator Improvementsp. 220
SQL Worksheet Improvementsp. 220
Data Grid Improvementsp. 221
PL/SQL Code Editor Improvementsp. 221
Reports Improvementsp. 221
SQL Developer Version 1.2p. 221
Indexp. 223
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780071484749
ISBN-10: 0071484744
Series: Oracle Press
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 230
Published: 10th October 2006
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.4 x 18.9  x 1.3
Weight (kg): 0.51
Edition Number: 1