Table of contents for Oracle SQL developer handbook / Dan Hotka.


Bibliographic record and links to related information available from the Library of Congress catalog
Note: Electronic data is machine generated. May be incomplete or contain other coding.


Counter
PART I
Getting Started
SProduct Installation, Upgrades, and System Requirements  . . ..          3 .
System Requirements to include Supported Databases . ......               4
Instaillation Process.
installing and Running SQL Discoverer on Windows . ......          5
installing and Running SQL Developer on L.nux  .. .................
Installing and Running SQL Developer on Mac OS  ................ .  6
Installing Newer Releases                                          6
Product  Versions  .  .  . .. .... .....  .  . ..... ... ... .. . . .... .  8
Getting  Help  ... . .. .. . ....  ..           ......9 9
oin  the  List G roup  . ..............             ......         9
Summary.....                                                             10
2   Getting Connected                            ....      .                I1
Working with Connections       .                                         12
Establishing New Connections                                             14
Sett  Up  Basic  Connections  ................  .....  ... .. ..  16
Setting Up TNS Connections  .16
Setting Up Custorn ]DBC Connections  ....  .....    ..             16
Connecting to Oracle  Og Express  . .. .  ..  ..    . .....  ..    16
Exporting/Importing Your Connections  . . .   .. . ..  . ..  . ...... .   . ..   . . .  17
Summary   ..                                                             17
3  Quick Start.                                                         19..... .  9
introduction to SQL Developer  .........0............            .  20
Establishing a Connection to the Database  .. . .... ... . ... ... ......  23
Navigating SQL Developer  ... ..  ... ......    ...  ..24
Viewing, Changing, and Saving Data  . ... ...... . . .  ...    27
Executing    .. ..     .. ....... ..... . .. .. ..... .. . .. ......  29
Viewing and Saving Output   .....   ...........                31
W orking with  SQ L         ......................                   33
Coding  Assistants  ......... ...... ....                      34
Using Code Templates  .............         ....               35
Using  SQ L  History  . ..................  ....               36
Executing SQL Scripts         ............                 .   37
Executing  PL/SQ L  .................................... .....  37
Usefut information from  Reports  ... ...                      38
Sum m ar  .y i...... . .. .... ....... ... ....... ...  .... ..... ...  39
PART If
Using SQL Developer
4  G eneral Inform ation    .......... ..............  ..  .. ... ...   43
"Viewing  and  Hiding  Toolbars  .... ........... .............. ..   44
Opening and  Closing  Interfaces  . .. ...  ..........  .. .  ...   44
Custom izing  the  Display  ... ............. ............     47
Dockable  W indows  .....p . ....... .. .. ... . ..... .. .  ... .  48
Pinning  D isplays  ........ . .... ...... ...... ..........   50
Autohide  Displays  . . ..... .. ..... ..... ... ..... ..... ..  50
Splitting Tab Displays  .. ....                                50
Preferences  ..... ..... . ......... ... ........... .. .... .  52
Summary  i.            ...   ....... ...             . ...       .   72
5  Working with the Connections Navigator  . .................. ..      73
W orking  w ith  O bjects  .  ........ .   I................. .. . ..... .  74
The Connections Navigator Toobar ......                        74
Working with Connections  ..... ...                            76
Working with Database Objects  . .. ...............            78
Sum m ary       ... .. .. . . ... .. .. .. .. . ... ... .. . ........ . ..  113
6  W orking  w ith  SQ L  . ... .... ..     ....... .....      .  .. .  115
The SQL W orksheet interface  ....................                  116
Entering  Accessing, and  Executing SQL  .  . ..... ........... ...... ..   119
Executing  PL/SQ L  .. .. ...        .............. .... .. ..   20
Creating  SQ L without Typing  ... .......... ...... . .......   121
M iscellaneous SQ L  Topics  . .. . ... ... ... .... ... ..... . .. .. ..  127
SQL History    .........                                      127
SO L  Form atting  .. .. ..  ....... ...... ... ......... ......  128
Saving  SQ L  .... .....................               ...    128
SQ L  O utput  .......  .. ... ....  ...... .. ..........  .  130
Sum m ary  . .. . . . . . . . . .. ... . . . .. .. .. . .. .. . . . . .. . . .. . . . . . . . ...  136
7  W orking with  PL/SQL  . .... ........ ...  ......          .. . :...  137
The SQL Developer PLISQL Editor nterface  ...                       138
Editing  PL/SQL Code  . ........... .. .......          .     139
Compiling  PLSQL Code  ....... ........  . ..........         139
Executing Packages, Procedures, and Functions                 141
Coding Productivity  .. 143
Using the PL/SQL Debugger  ........       .....               146
Summary  .....                                                      159
8  Additional Topics  ... ..  .. .... ., ... ...... ...... .. ... .... ... .  161
Find  and  Replace Text  ..... . .................                  162
Using Find and Replace Features  ..........                   162
Using Incremental Find Forward/Backward  . ..... .. . . .  .  .  .  .   .  1. .  63
Quickly Navigating Around Code         .......                      164
Using  Bookm arks  ......... ...... ...............  .......  164
Using Line Numbers                      ...........           165
D atabase  Export  ........... .. .. .... ...  .....  .... .. ... ..  66
Summary                                                             169
PART III
SQ_L Developer Reports
9  Available  Reports      .... ..... ...... ................ .....    173
Running Reports                                                    174
Driabe  Reports    ................                                 178
Data  D ictionary  Reports  .... ..... ..... . ................. ......  179
About Your Database  ....   . ............ . .. .......       180
Database  Administration   .......... ... ... .......    ...  181
Tab le  . . . . . .. . . .  . . .. . . . . . . .. . . . . .. .  . . . . . .. . .   196
PL/SQ L  . .  . . ... . . . . . . .  . . . . . . . . . . .. . . . . . .. . .. . .. . . . ..  196
Security  ..  .... .... . .... . ... ... ....... . .........  197
XM L  .........  . .  .  . ..   .  . ... ... .. ..  .. ..  .. .. .  199
lobs  ......      ....                                        200
Stream s  ...  . ......... . ... .................       . ..  200
A ll O bjects  .... ....... . ..... .. ...... ..... ...... . .   20 1
Data  D ictionary  . ... .... ...... ....... ........ ........  202
Surnm ary      .. ..... ..............  .. .............. ......    204
10   User-Defined  Reports  . ...... ............ . .. ...............  205
Adding Categories                                                   206
Adding  Reports  ...........  .. ........... ...... ... ..... . ..  208
Reports with Optional Input Variables  .  ... ... ... . . .   .   .   . .   . .  209
Sum m ary  ........        .. ....... ...                ....    .  210
PART IV
Appendixes
A   Feature, Function, and Keystroke Cross-Reference  . . .. . .  .  . . .  21
Keystroke Cross- RefTer  nce           ...... ... .. .. ........       2 1. 214
Feature/Function  Cross-Reference  ........ ....  . ........ . ........ .  216
um  nary      .  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 17
B   SQL Developer Version 1 1 and Beyond  ...      ... 219
SQL Developer Version  ,  .1  .   .. .  . . . ....                     220
Generai interface Improvements                                   220
Obiect Navigator Improvements  .....    .....   ......  ... ..   220
SQL W orksheet improvements  .............   ..........   .....  220
Data Grid improvements ..      .....        .                    221
PL/SQL Code Editor mprovements      ....  ......   ..   . .       21
Reports Improvements  . . . ..... ...      .....                 221
SOL Developer Version 12             . ...........                     221



Library of Congress subject headings for this publication: Oracle (Computer file)SQL (Computer program language)