Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Z 

A

accelerator keys
for menus, 1.2
accelerators (keyboard shortcuts), 1.13.2
Access (Microsoft) connections, 4.12
Active Session History (ASH) reports, 1.12.4
Advanced Security for JDBC connection, 1.4.3
analyzing tables, 1.3.18
application
deploying (Application Express), 4.54
importing (Application Express), 4.54
Application Express
applications, 1.3.1
deploying an application, 4.54
importing an application, 4.54
Publish to Apex option, 1.5
starting and stopping EPG (embedded PL/SQL gateway), 1.3.1
applications
Application Express, 1.3.1
Apply Filter
to display of objects, 1.2, 4.68
ASH (Active Session History) reports, 1.12.4
associations
file types, 4.48
authentication
Kerberos, 4.12
Database Advanced Parameters, 1.13.5
OS (operating system), 4.12
autocommit
preference for database connections, 1.13.5
autocomplete preferences, 1.13.3
autocompletion
Source menu, 1.2.1
Automated Workload Repository (AWR) reports, 1.12.4
autotrace
Autotrace pane, 1.7.4
preferences for, 1.13.5
AWR (Automated Workload Repository) reports, 1.12.4

B

Berkeley DB
data storage for Subversion repository, 4.35
bind variables
for reports, 1.12
saving to disk on exit, 1.13.5
blogs
SQL Developer, 1.17
breakpoints
creating and editing, 4.106

C

cache groups, 1.3.2
case insensitivity for queries
setting, 2.10
charts
user-defined report example, 1.12.15.1
check constraints, 4.38
Check for Updates feature, 4.3
CLOBtoBLOB_sqldeveloper stored procedure, 1.13.10
close all SQL Worksheets automatically on disconnect
preference for database connections, 1.13.5
coalescing an index, 1.3.6
code completion
Source menu, 1.2.1
code fragments, 1.8
code insight, 1.13.3
column sequences, 4.38
columns
decrypting, 1.3.18
encrypting, 1.3.18
normalizing column data, 1.3.18
Compact option for shrinking a table, 1.3.18
compiling
function, 1.3.5
for debug, 1.3.5
procedure, 1.3.11
for debug, 1.3.11
view, 1.3.22
completion
SQL Developer preferences, 1.13.3
completion insight, 1.13.3
Source menu, 1.2.1
configuring, 2.5.1, 2.5.1
third-party databases, 2.5
configuring file type associations, 4.48
connections
creating, editing, or selecting, 4.12
explanation, 1.4
Microsoft Access, 4.12
Microsoft SQL Server, 4.12
MySQL, 4.12
Oracle Database, 4.12
Oracle TimesTen, 4.12
separate unshared worksheet for, 1.4, 1.7
Sybase Adaptive Server, 4.12
using folders to group, 1.4.1
constraints
check, 4.38
disabled, 1.12.12
unique, 4.38
converted model
correcting errors in, 2.7.1
creating and customizing, 2.7
custom export delimiter
preference for database connections, 1.13.5
customizing SQL Developer
setting preferences, 1.13
CVS (Concurrent Versions System)
preferences for, 1.13.11
SQL Developer support for, 1.11

D

data
entering and modifying, 1.5
data move
generating user, 1.13.10
number of parallel streams, 1.13.10
options, 1.13.10
data types
creating, 4.41
database connections, 4.12
creating, editing, or selecting, 4.12
explanation, 1.4
Microsoft Access, 4.12
Microsoft SQL Server, 4.12
MySQL, 4.12
Oracle Database, 4.12
Oracle TimesTen, 4.12
Sybase Adaptive Server, 4.12
database links, 1.3.3
creating or editing, 4.25
database objects, 1.3
exporting, 4.59
searching for, 1.9
database schema differences
differences between two database schemas, 4.51
DB Object Search pane, 1.9
DBMS_OUTPUT
user-defined report example, 1.12.15.2
DBMS_OUTPUT pane, 1.7.5
debugging PL/SQL function or procedure, 1.6
dialog box, 4.105
remote debugging, 1.6.2
decryption
data in a table column, 1.3.18
deployment
after database migration, 2.12
destination schema
database schema differences, 4.51
dialog boxes and tabs, 4
directories (directory objects), 1.3.4
disabled constraints, 1.12.12
discussion forum
SQL Developer, 1.17
documentation
generating for schema, 1.4
downloads
SQL Developer, 1.17
drag and drop effects, 1.13.5
drivers
third-party JDBC, 1.13.5
dynamic HTML
user-defined report example, 1.12.15.2

E

embedded PL/SQL gateway (EPG) for Application Express
starting and stopping, 1.3.1
encryption
data in a table column, 1.3.18
entering data in tables, 1.5
EPG (embedded PL/SQL gateway) for Application Express
starting and stopping, 1.3.1
errors
parse exceptions, 2.7.1
Excel
importing data, 4.23
execution plan, 1.7.3
EXPLAIN PLAN
execution plan, 1.7.3
exporting
applying filters, 4.60
database objects, 4.59
reports, 1.12
table data, 1.3.18, 4.61, 4.62
expression watches, 1.6.5
extended search, 1.10
extensions, 4.65
SQL Developer, 1.13.7
user-defined, 1.13.5
external tables
properties, 4.38
external tools, 1.2.1, 4.64, 4.65

F

F10 key
for File menu, 1.2
F4 key, 1.7
failed objects
generating, 1.13.10
file types
associating with SQL Developer, 4.48
file-oriented development
SQL Worksheet right-click operations, 1.7
Files navigator, 1.2
filter
applying, 1.2, 4.68
clearing, 1.2, 4.68
Find DB Object pane, 1.9
Flashback Table support, 1.3.18.1
folders
for user-defined reports, 1.12.15, 4.44
in Connections navigator, 1.4.1
font
increasing or decreasing size for help text, 1.16
foreign keys, 4.38
Freeze View
pinning an object’s display, 1.2, 1.5, 1.12
FROM clause, 4.45
full pathname for java.exe, 1.1
functions
compiling, 1.3.5
compiling for debug, 1.3.5
creating, 4.30
debugging, 4.105
running, 4.105

G

Gather Schema Statistics menu command, 1.4
gauges
in SQL Worksheet and user-defined reports, 1.7.8
generate data move user option, 1.13.10
Generate DB Doc menu command, 1.4
generate failed objects option, 1.13.10
graphical user interface (GUI), 1.2, 2.14
GROUP BY clause, 4.45
groups
connections in folders, 1.4.1

H

HAVING clause, 4.45
help
increasing or decreasing help text font size, 1.16
using the online help, 1.16
hierarchical profiler (PL/SQL), 1.6.4
HTML
dynamic (user-defined report), 1.12.15.2

I

importing
Microsoft Excel data, 4.23
reports, 1.12
indexes, 4.38
coalescing, 1.3.6
creating or editing, 4.26
explanation, 1.3.6
making unusable, 1.3.6
rebuilding, 1.3.6
index-organized tables
properties, 4.38
introduction
SQL Developer, 1

J

Java sources, 1.3.7
java.exe
pathname for, 1.1
JDBC drivers, 1.13.5
jTDS
JDBC driver for Microsoft SQL Server and Sybase Adaptive Server, 1.13.5

K

Kerberos authentication, 4.12
Database Advanced Parameters, 1.13.5
keyboard shortcuts, 1.13.2

L

least privilege schema migration, 1.13.10
link
database, 4.25
LOB parameters, 4.38
locking a table, 1.3.18
lowercase characters in object names
quotation marks required, 4

M

materialized view logs, 1.3.9
creating and editing, 4.28
materialized views, 1.3.8
options when creating or editing, 4.45
Microsoft Access
capturing using exporter tool, 2.5.2.1
configuring before migrating, 2.5.2
creating data files, 2.9.1.2
turning off security, 2.5.2
Microsoft Access connections, 4.12
Microsoft Excel
importing data, 4.23
Microsoft SQL Server, 2.5.1
connections, 4.12
creating data files, 2.9.1.1
third-party JDBC drivers, 1.13.5
migration
architecture, 2.2.1
before you start (general), 2.4
before you start (source-specific), 2.5
deployment after migrating, 2.12
introduction and main topics, 2
overview, 2.2
planning for, 2.3
quick start, 2.1
required roles and privileges, 2.4.2
migration plan
preparing, 2.3
migration repository
creating database user for, 2.4.1
MOD_PLSQL
OWA output, 1.7.6
modifying data in tables, 1.5
Monitor Sessions command, 1.2.1
Monitor SQL command, 1.2.1
moving a table to another tablespace, 1.3.18
MySQL
configuring before migrating, 2.5.3
creating data files, 2.9.1.3
third-party JDBC drivers, 1.13.5
MySQL connections, 4.12
zero date handling, 4.12

N

normalizing
column data, 1.3.18

O

object search
extended search, 1.10
Find DB Object pane, 1.9
objects
database, 1.3
exporting, 4.59
OCI driver
database advanced parameters preference, 1.13.5
offline data transfer, 2.9.1
offline generation of Oracle DDL, 4.76
online help
using, 1.16
open SQL Worksheet automatically
preference for database connections, 1.13.5
operating system authentication, 4.12
Oracle Application Express
applications, 1.3.1
Oracle Database connections, 4.12
Oracle Web Agent (OWA), 1.7.6
ORDER BY clause, 4.45
OS authentication, 4.12
OTN page
SQL Developer, 1.17
overview
SQL Developer, 1
OWA_OUTPUT pane, 1.7.6

P

packages
creating, 4.29
debugging, 4.105
running, 4.105
parallel data move streams, 1.13.10
parameter insight, 1.13.3
parse exception errors, 2.7.1
partitioned tables
partition definitions, 4.38
partitioning options, 4.38
subpartitioning options (templates), 4.38
pathname
for java.exe, 1.1
pinning an object’s display, 1.2, 1.5, 1.12
PL/SQL hierarchical profiler, 1.6.4
PL/SQL packages
creating, 4.29
PL/SQL subprograms
creating, 4.30
debugging, 4.105
breakpoints, 4.106
running, 4.105
plsql-dbms_output
user-defined report example, 1.12.15.2
preferences
customizing SQL Developer, 1.13
primary key, 4.38
private database links, 1.3.3
private synonyms, 1.3.17, 4.36
privileges
required for migration, 2.4.2
procedures
compiling, 1.3.11
compiling for debug, 1.3.11
creating, 4.30
profiler (PL/SQL hierarchical), 1.6.4
profiling a PL/SQL function or procedure, 4.105
projects
creating plan, 2.3.3
proxy authentication, 1.4.5
proxy connections, 1.4.5, 4.12
public database links, 1.3.3
public synonyms, 1.3.17, 4.36
Publish to Apex (Application Express) option, 1.5

Q

query builder, 4.94
quotation marks
for name with lowercase characters, special characters, or spaces, 4

R

Raptor
former code name for SQL Developer, 1
rebuilding an index, 1.3.6
recompiling
view, 1.3.22
Recycle bin, 1.3.14
remote debugging, 1.6.2
replication schemes, 1.3.15
report navigator, 1.12
reports, 1.12
bind variables for, 1.12
exporting, 1.12
importing, 1.12
shared, 1.12
user-defined
chart example, 1.12.15.1
creating and editing, 4.43
dynamic HTML example, 1.12.15.2
explanation, 1.12.15
folders for, 1.12.15, 4.44
gauge example, 1.7.8
UserReports.xml, 1.12.15
roles
required for migration, 2.4.2
running PL/SQL function or procedure, 1.6
dialog box, 4.105

S

schema
XML, 1.3.23, 4.46
schema differences
differences between two database schemas, 4.51
schema documentation
generating, 1.4
schema objects, 1.3
schema statistics
gathering, 1.4
scratch editor, 2.14.5
script runner, 1.7.2
scripts
running, 1.7.2
search
extended, 1.10
security
Advanced Security for JDBC connection, 1.4.3
SELECT clause, 4.45
sequences, 1.3.16
creating and editing, 4.32
for populating table columns, 4.38
sessions
monitoring, 1.2.1
shared reports, 1.12
shortcut keys
accelerator key mappings, 1.13.2
for menus, 1.2
shrinking a table, 1.3.18
single record view, 4.119
size of help text
increasing or decreasing, 1.16
snippets, 1.8
user-defined, 1.8.1
source database
capturing, 2.6
source schema
database schema differences, 4.51
spaces in object names
quotation marks required, 4
special characters in object names
quotation marks required, 4
split
data pane for a table or view, 1.5
SQL
monitoring execution, 1.2.1
SQL Developer preferences, 1.13
SQL file
creating, 4.33
SQL scripts
running, 1.7.2
SQL Server
configuring, 2.5.1
creating data files, 2.9.1.1
third-party JDBC drivers, 1.13.5
SQL Server connections, 4.12
SQL Trace files (.trc), 1.6.3
SQL Worksheet
closing automatically on disconnect, 1.13.5
opening automatically on database connection, 1.13.5
unshared for a connection, 1.4, 1.7
using, 1.7
SQLDEVELOPER_USER_DIR location, 1.14
statistics
computing table and column, 1.3.18
estimating table and column, 1.3.18
gathering schema, 1.4
storage options, 4.39
stored procedures
generating for Migrate Blobs Offline, 1.13.10
subpartitions
templates, 4.38
subprograms
creating, 4.30
debugging, 4.105
running, 4.105
substitution variables, 1.7.2
Subversion
preferences for, 1.13.11
SQL Developer support for, 1.11
Sybase Adaptive Server, 2.5.1
connections, 4.12
creating data files, 2.9.1.1
third-party JDBC drivers, 1.13.5
synonyms, 1.3.17
creating and editing, 4.36

T

tables, 1.3.18
analyzing, 1.3.18
compacting, 1.3.18
computing statistics, 1.3.18
creating and editing, 4.38
creating quickly, 4.37
decrypting column data, 1.3.18
encrypting column data, 1.3.18
entering and modifying data, 1.5
estimating statistics, 1.3.18
exporting data, 1.3.18, 4.61, 4.62
external
properties, 4.38
index-organized
properties, 4.38
locking, 1.3.18
moving to another tablespace, 1.3.18
normalizing column data, 1.3.18
partitioned
partition definitions, 4.38
partitioning options, 4.38
subpartitioning options (templates), 4.38
shrinking, 1.3.18
splitting the data pane, 1.5
temporary, 4.38
truncating, 1.3.18
validating structure, 1.3.18
temporary tables, 4.38
thick (OCI) driver
database advanced parameters preference, 1.13.5
third-party databases
configuring before migrating, 2.5
third-party JDBC drivers, 1.13.5
TimesTen
cache groups, 1.3.2
database connections, 4.12
replication schemes, 1.3.15
support for in SQL Developer, 1.15
TKPROF
opening in SQL Developer as an alternative to using, 1.6.3
tnsnames.ora file, 1.4
tools
external, 1.2.1, 4.64, 4.65
trace files (.trc), 1.6.3
transferring
data offline, 2.9.1
translation scratch editor, 2.14.5
.trc files, 1.6.3
triggers, 1.3.19
creating and editing, 4.40
truncating a table, 1.3.18
T-SQL
not supported in worksheet for SQL Server or Sybase connection, 2.14.5
translation to PL/SQL, 2.14.5
tutorial
creating objects for a small database, 3
types
creating, 4.41

U

unique constraints, 4.38
unshared worksheet for a connection, 1.4, 1.7
unusable indexes, 1.3.6
updates
checking for SQL Developer updates, 4.3
user information directory (SQLDEVELOPER_USER_DIR), 1.14
user interface
restoring to original settings, 1.2.2
user interface (UI), 1.2, 2.14
user-defined extensions, 1.13.5
user-defined reports
chart example, 1.12.15.1
creating and editing, 4.43
dynamic HTML example, 1.12.15.2
explanation, 1.12.15
folders for, 1.12.15, 4.44
gauge example, 1.7.8
UserReports.xml, 1.12.15
user-defined snippets, 1.8.1
user-defined types
creating, 4.41
UserReports.xml, 1.12.15
users
creating and editing, 4.42

V

versioning
preferences for, 1.13.11
SQL Developer support for, 1.11
viewlets
SQL Developer, 1.17
views, 1.3.22
compiling, 1.3.22
creating and editing, 4.45
FROM clause, 4.45
GROUP BY clause, 4.45
HAVING clause, 4.45
options when creating or editing, 4.45
ORDER BY clause, 4.45
recompiling, 1.3.22
SELECT clause, 4.45
splitting the data pane, 1.5
WHERE clause, 4.45

W

watches, 1.6.5
WHERE clause, 4.45

X

XML schema, 1.3.23
creating, 4.46

Z

zero date handling
MySQL connections, 4.12