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

abstract syntax tree (AST), 1.18.11
accelerator (shortcut) keys, 1.18.13
for menus, 1.2
Access (Microsoft) connections, 5.21
Active Session History (ASH) reports, 1.17.4
Advanced Security for JDBC connection, 1.4.3
analyzing tables, 1.3.29
application
deploying (Application Express), 5.76
importing (Application Express), 5.76
Application Express
applications, 1.3.1
deploying an application, 5.76
importing an application, 5.76
Publish to Apex option, 1.5
refactor in bulk command, 1.3.1
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, 5.95
ASH (Active Session History) reports, 1.17.4
associations
file types, 5.66
AST (abstract syntax tree), 1.18.11
authentication
Kerberos, 5.21
Database Advanced Parameters, 1.18.5
OS (operating system), 5.21
autocommit
preference for database connections, 1.18.5
autocomplete preferences, 1.18.3
autogenerated connections, 1.4
Auto-Generated connections folder, 1.4
Automated Workload Repository (AWR) reports, 1.17.4
autotrace
Autotrace pane, 1.7.4
preferences for, 1.18.5
AWR (Automated Workload Repository) reports, 1.17.4

B

bequeath connection type, 5.21
Berkeley DB
data storage for Subversion repository, 5.171
bind variables
for reports, 1.17
saving to disk on exit, 1.18.5
blogs
SQL Developer, 1.24
breakpoints
creating and editing, 5.143

C

cache groups, 1.3.2
Cart (SQL Developer), 1.13
case insensitivity for queries
setting, 2.2.9
CDB
definition, 1.3.18
chains (Scheduler), 1.3.3
creating and editing, 5.18
charts
user-defined report example, 1.17.15.1
check constraints, 5.54
Check for Updates feature, 5.6
CLOBtoBLOB_sqldeveloper stored procedure, 1.18.11
close all SQL Worksheets automatically on disconnect
preference for database connections, 1.18.5
clustered primary keys (Sybase)
generating as Oracle index-organized tables, 1.18.11
clustered unique indexes (Sybase)
generating as Oracle index-organized tables, 1.18.11
coalescing an index, 1.3.12
code coverage
gathering and viewing statistics, 3.4
code fragments, 1.8
code insight (completion insight), 1.18.3
column sequences, 5.54
columns
decrypting, 1.3.29
encrypting, 1.3.29
normalizing column data, 1.3.29
Compact option for shrinking a table, 1.3.29
compiling
function, 1.3.11, 1.3.20
for debug, 1.3.11, 1.3.20
view, 1.3.33
completion
SQL Developer preferences, 1.18.3
completion insight, 1.18.3
compound triggers, 1.18.11
configuring, 2.2.4.2, 2.2.4.2
third-party databases, 2.2.4
configuring file type associations, 5.66
connections
creating, editing, or selecting, 5.21
explanation, 1.4
IBM DB2, 5.21
JDBC, 5.21
Microsoft Access, 5.21
Microsoft SQL Server, 5.21
MySQL, 5.21
Oracle Database, 5.21
Oracle TimesTen, 5.21
separate unshared connection preference, 1.18.5
separate unshared worksheet for, 1.4, 1.7
Sybase Adaptive Server, 5.21
Teradata, 5.21
using folders to group, 1.4.1
constraints
check, 5.54
disabled, 1.17.12
unique, 5.54
converted model
correcting errors in, 2.2.6.1
creating and customizing, 2.2.6
Create Local Connections command, 1.4
Create Unit Test wizard, 5.203
credentials (Scheduler), 1.3.4
creating and editing, 5.19
crossedition triggers, 1.3.30
customizing SQL Developer
setting preferences, 1.18
CVS (Concurrent Versions System)
preferences for, 1.18.15
SQL Developer support for, 1.10

D

data
entering and modifying, 1.5
Data Modeler
included in SQL Developer, 1.20
data move
generating user, 1.18.11
number of parallel streams, 1.18.11
options, 1.18.11
Data Pump Export wizard, 5.69
Data Pump Import wizard, 5.70
data types
creating, 5.58
database administrator (DBA) features in SQL Developer, 1.11
database connections, 5.21
creating, editing, or selecting, 5.21
explanation, 1.4
IBM DB2, 5.21
JDBC, 5.21
Microsoft Access, 5.21
Microsoft SQL Server, 5.21
MySQL, 5.21
Oracle Database, 5.21
Oracle TimesTen, 5.21
Sybase Adaptive Server, 5.21
Teradata, 5.21
database destination groups (Scheduler), 1.3.7
creating and editing, 5.38, 5.38
database destinations (Scheduler), 1.3.5
creating and editing, 5.37
database links, 1.3.6
creating or editing, 5.39
database objects, 1.3
exporting, 5.73
finding (searching for), 1.9
unloadiing, 5.73
database schema differences
differences between two database schemas, 5.72
DB2
before migrating, 2.2.4.1
DB2 (IBM) connections, 5.21
DBA features in SQL Developer
using, 1.11
DBMS_OUTPUT
user-defined report example, 1.17.15.2
DBMS_OUTPUT pane, 1.7.5
debugging PL/SQL function or procedure, 1.6
dialog box, 5.142
remote debugging, 1.6.2
decryption
data in a table column, 1.3.29
deploying objects using the Cart, 1.13
deployment
after database migration, 2.2.11
destination groups (Scheduler), 1.3.7
creating and editing, 5.38
destination schema
database schema differences, 5.72
destinations
database (Scheduler), 1.3.5
dialog boxes and tabs, 5
directories (directory objects), 1.3.8
disabled constraints, 1.17.12
discussion forum
SQL Developer, 1.24
documentation
generating for schema, 1.4
downloads
SQL Developer, 1.24
drag and drop effects, 1.18.5
drivers
third-party JDBC, 1.18.5
dynamic HTML
user-defined report example, 1.17.15.2

E

editions, 1.3.9
crossedition triggers, 1.3.30
embedded PL/SQL gateway (EPG) for Application Express
starting and stopping, 1.3.1
emulation user
generating separate, 1.18.11
encryption
data in a table column, 1.3.29
entering data in tables, 1.5
EPG (embedded PL/SQL gateway) for Application Express
starting and stopping, 1.3.1
errors
parse exceptions, 2.2.6.1
Excel
importing data, 5.35
execution plan, 1.7.3
expired password
resetting, 1.4
EXPLAIN PLAN
execution plan, 1.7.3
exporting
database objects, 5.73
reports, 1.17
table data, 1.3.29, 5.83
unit test objects, 3.10
expression watches, 1.6.5
extensions, 5.87
SQL Developer, 1.18.7
user-defined, 1.18.5
external destination groups (Scheduler), 1.3.7
external editor
SQL Developer preferences, 1.18.8
external tables
properties, 5.54
external tools, 1.2.1, 5.86, 5.87

F

F10 key
for File menu, 1.2
F4 key, 1.7
Alt+F4 to close window with focus, 1.2
failed objects
generating, 1.18.11
file types
associating with SQL Developer, 5.66
file watchers (Scheduler), 1.3.10
file-oriented development
SQL Worksheet right-click operations, 1.7
Files navigator, 1.2
filter
applying, 1.2, 5.95
clearing, 1.2, 5.95
finding database objects, 1.9
Flashback Table support, 1.3.29.1
folders
for user-defined reports, 1.17.15, 5.61
in Connections navigator, 1.4.1
font
increasing or decreasing size for help text, 1.22
foreign keys, 5.54
format batch file or shell script, 1.7.9
Freeze View
pinning an object’s display, 1.2, 1.5, 1.17
FROM clause, 5.62
full pathname for java.exe, 1.1
functions
compiling, 1.3.11, 1.3.20
compiling for debug, 1.3.11, 1.3.20
creating, 5.46
debugging, 5.142
running, 5.142

G

Gather Code Coverage Statistics option, 3.4
Gather Schema Statistics menu command, 1.4
gauges
in SQL Worksheet and user-defined reports, 1.7.10
generate data move user option, 1.18.11
Generate DB Doc menu command, 1.4
generate failed objects option, 1.18.11
generate separate emulation user option, 1.18.11
grant information
not migrated to Oracle, 2.2.3
graphical user interface (GUI), 1.2, 2.3
unit testing, 3.2
GROUP BY clause, 5.62
groups
connections in folders, 1.4.1

H

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

I

IBM DB2
before migrating, 2.2.4.1
IBM DB2 connections, 5.21
IDE_USER_DIR location, 1.19
implementation
adding for a unit test, 5.199, 5.200, 5.201
renaming for a unit test, 5.205
importing
Microsoft Excel data, 5.35
reports, 1.17
unit test objects, 3.10
indexes, 5.54
coalescing, 1.3.12
creating or editing, 5.40
explanation, 1.3.12
making unusable, 1.3.12
rebuilding, 1.3.12
index-organized tables
properties, 5.54
introduction
SQL Developer, 1

J

Java sources, 1.3.13
java.exe
pathname for, 1.1
JDBC connections, 5.21
JDBC drivers, 1.18.5
job classes (Scheduler), 1.3.15
creating and editing, 5.43
job scheduler
using in SQL Developer, 1.12
jobs
scheduling using SQL Developer, 1.12
jobs (Scheduler), 1.3.14
creating and editing, 5.42
jTDS
JDBC driver for Microsoft SQL Server and Sybase Adaptive Server, 1.18.5

K

Kerberos authentication, 5.21
Database Advanced Parameters, 1.18.5
keyboard shortcuts, 1.18.13

L

least privilege schema migration, 1.18.11
library
adding an item for unit testing, 5.198
unit testing, 3.8
link
database, 5.39
LOB parameters, 5.54
local connections
creating, 1.4
locking a table, 1.3.29
lookups
adding for unit testing, 5.196, 5.197
lowercase characters in object names
quotation marks required, 5

M

materialized view logs, 1.3.17
creating and editing, 5.44
materialized views, 1.3.16
options when creating or editing, 5.62
Microsoft Access
capturing using exporter tool, 2.2.4.3.1
configuring before migrating, 2.2.4.3
creating data files, 2.2.8.1.2
turning off security, 2.2.4.3
Microsoft Access connections, 5.21
Microsoft Excel
importing data, 5.35
Microsoft SQL Server, 2.2.4.2
connections, 5.21
creating data files, 2.2.8.1.1
third-party JDBC drivers, 1.18.5
migration
architecture, 2.2.1.1
before you start (general), 2.2.3
before you start (source-specific), 2.2.4
command-line interface, 2.4
deployment after migrating, 2.2.11
introduction and main topics, 2
overview, 2.2.1
planning for, 2.2.2
quick start, 2.1
required roles and privileges, 2.2.3.2
migration batch file or shell script, 2.4
migration plan
preparing, 2.2.2
migration repository
creating database user for, 2.2.3.1
MIME type
specifying external editor for BLOB data, 1.18.8
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.29
multitenant container database (CDB)
definition, 1.3.18
MySQL
configuring before migrating, 2.2.4.4
creating data files, 2.2.8.1.3
third-party JDBC drivers, 1.18.5
MySQL connections, 5.21
zero date handling, 5.21

N

New Worksheet to use unshared connection
preference for database SQL Worksheet
using unshared connection automatically, 1.18.5
normalizing
column data, 1.3.29

O

OBEs (Oracle By Example lessons), 1.24
objects
database, 1.3
exporting, 5.73
unloadiing, 5.73
OCI driver
database advanced parameters preference, 1.18.5
offline data transfer, 2.2.8.1
online help
using, 1.22
Open command on Connections navigator context menu
open SQL Worksheet automatically
preference for database connections, 1.18.5
operating system authentication, 5.21
ORA_ROWSCN pseudocolumn
"Use ORA_ROWSCN for DataEditor insert and update statements" preference, 1.18.5
Oracle Application Express
applications, 1.3.1
Oracle By Example (OBE) lessons, 1.24
Oracle Database 12c features
generating in migration, 1.18.11
Oracle Database connections, 5.21
Oracle Web Agent (OWA), 1.7.6
ORDER BY clause, 5.62
OS authentication, 5.21
OTN page
SQL Developer, 1.24
overview
SQL Developer, 1
overview display of database objects
Open command on context menu, 1.3
OWA_OUTPUT pane, 1.7.6

P

packages
creating, 5.45
debugging, 5.142
running, 5.142
parallel data move streams, 1.18.11
parameter insight, 1.18.3
parse exception errors, 2.2.6.1
partitioned tables
partition definitions, 5.54
partitioning options, 5.54
subpartitioning options (templates), 5.54
password
resetting expired, 1.4
pathname
for java.exe, 1.1
PDB
definition, 1.3.18
pinning an object’s display, 1.2, 1.5, 1.17
PL/SQL hierarchical profiler, 1.6.4
PL/SQL packages
creating, 5.45
PL/SQL subprograms
creating, 5.46
debugging, 5.142
breakpoints, 5.143
running, 5.142
plsql-dbms_output
user-defined report example, 1.17.15.2
pluggable database (PDB)
definition, 1.3.18
preferences
customizing SQL Developer, 1.18
preferences (options), 1.18.14
primary key, 5.54
private database links, 1.3.6
private synonyms, 1.3.28, 5.52
privileges
required for migration, 2.2.3.2
procedures
creating, 5.46
profiler (PL/SQL hierarchical), 1.6.4
profiling a PL/SQL function or procedure, 5.142
programs (Scheduler), 1.3.21
creating and editing, 5.47
projects
creating plan, 2.2.2.3
proxy authentication, 1.4.5
proxy connections, 1.4.5, 5.21
public database links, 1.3.6
public synonyms, 1.3.28, 5.52
Publish to Apex (Application Express) option, 1.5

Q

query builder, 1.7.8
quotation marks
for name with lowercase characters, special characters, or spaces, 5

R

Raptor
former code name for SQL Developer, 1
rebuilding an index, 1.3.12
recompiling
view, 1.3.33
Recycle bin, 1.3.24
refactor in bulk, 1.3.1
remote debugging, 1.6.2
replication schemes, 1.3.25
report navigator, 1.17
reports, 1.17
bind variables for, 1.17
exporting, 1.17
importing, 1.17
shared, 1.17
unit testing, 3.9
user-defined
chart example, 1.17.15.1
creating and editing, 5.60
dynamic HTML example, 1.17.15.2
explanation, 1.17.15
folders for, 1.17.15, 5.61
gauge example, 1.7.10
UserReports.xml, 1.17.15
repository
unit test, 3.3
Reset Password menu command, 1.4
roles
creating and editing, 5.48
required for migration, 2.2.3.2
running PL/SQL function or procedure, 1.6
dialog box, 5.142

S

scheduler
using in SQL Developer, 1.12
schedules (Scheduler), 1.3.26
creating and editing, 5.49
scheduling jobs in SQL Developer, 1.12
schema
XML, 1.3.35, 5.63
schema differences
differences between two database schemas, 5.72
schema documentation
generating, 1.4
schema objects, 1.3
schema statistics
gathering, 1.4
scratch editor, 2.3.5
script runner, 1.7.2
scripts
running, 1.7.2
search
for database objects, 1.9
security
Advanced Security for JDBC connection, 1.4.3
SELECT clause, 5.62
sequences, 1.3.27
creating and editing, 5.50
for populating table columns, 5.54
sessions
monitoring, 1.2.1
shared reports, 1.17
shared repository, 3.3
shortcut keys, 1.18.13
for menus, 1.2
restoring to default scheme, 1.18.13
shrinking a table, 1.3.29
single record view, 5.157
size of help text
increasing or decreasing, 1.22
snippets, 1.8
user-defined, 1.8.1
source database
capturing, 2.2.5
source schema
database schema differences, 5.72
spaces in object names
quotation marks required, 5
Spatial support
Maintain Spatial Metadata dialog box, 5.115
Validate Geometry dialog box, 5.209
special characters in object names
quotation marks required, 5
split
data pane for a table or view, 1.5
SQL
monitoring execution, 1.2.1
SQL Developer preferences, 1.18
SQL file
creating, 5.51
SQL formatting
command-line interface, 1.7.9
SQL scripts
running, 1.7.2
SQL Server
configuring, 2.2.4.2
creating data files, 2.2.8.1.1
third-party JDBC drivers, 1.18.5
SQL Server connections, 5.21
SQL Trace files (.trc), 1.6.3
SQL Worksheet
closing automatically on disconnect, 1.18.5
opening automatically on database connection, 1.18.5
unshared for a connection, 1.4, 1.7
using, 1.7
Start Page for SQL Developer, 1.24
statistics
computing table and column, 1.3.29
estimating table and column, 1.3.29
gathering schema, 1.4
storage options, 5.55
stored procedures
generating for Migrate Blobs Offline, 1.18.11
subpartitions
templates, 5.54
subprograms
creating, 5.46
debugging, 5.142
running, 5.142
substitution variables, 1.7.2
Subversion
preferences for, 1.18.15
SQL Developer support for, 1.10
Sybase Adaptive Server, 2.2.4.2
connections, 5.21
creating data files, 2.2.8.1.1
third-party JDBC drivers, 1.18.5
Sybase clustered primary keys
generating as Oracle index-organized tables, 1.18.11
Sybase clustered unique indexes
generating as Oracle index-organized tables, 1.18.11
Synchronize Unit Test wizard, 5.207
synonyms, 1.3.28
creating and editing, 5.52

T

tables, 1.3.29
analyzing, 1.3.29
compacting, 1.3.29
computing statistics, 1.3.29
creating and editing, 5.54
creating quickly, 5.53
decrypting column data, 1.3.29
encrypting column data, 1.3.29
entering and modifying data, 1.5
estimating statistics, 1.3.29
exporting data, 1.3.29, 5.83
external
properties, 5.54
index-organized
properties, 5.54
locking, 1.3.29
moving to another tablespace, 1.3.29
normalizing column data, 1.3.29
partitioned
partition definitions, 5.54
partitioning options, 5.54
subpartitioning options (templates), 5.54
shrinking, 1.3.29
splitting the data pane, 1.5
temporary, 5.54
truncating, 1.3.29
validating structure, 1.3.29
tablespaces
creating and editing, 5.56
temporary tables, 5.54
Teradata
before migrating, 2.2.4.5
connections, 5.21
test case
definition of, 3.1
test suite
definition of, 3.1
thick (OCI) driver
database advanced parameters preference, 1.18.5
third-party databases
configuring before migrating, 2.2.4
third-party JDBC drivers, 1.18.5
TimesTen
cache groups, 1.3.2
database connections, 5.21
replication schemes, 1.3.25
support for in SQL Developer, 1.21
Tip of the Day, 1.23
TKPROF
opening in SQL Developer as an alternative to using, 1.6.3
tnsnames.ora file, 1.4
tools
external, 1.2.1, 5.86, 5.87
trace files (.trc), 1.6.3
transferring
data offline, 2.2.8.1
translation scratch editor, 2.3.5
.trc files, 1.6.3
triggers, 1.3.30
compound, 1.18.11
creating and editing, 5.57
truncating a table, 1.3.29
T-SQL
not supported in worksheet for SQL Server or Sybase connection, 2.3.5
translation to PL/SQL, 2.3.5
tutorial
creating objects for a small database, 4
types
creating, 5.58

U

unique constraints, 5.54
unit test
definition of (as related to test cases), 3.1
unit testing, 1.18.14
adding a category for lookups, 5.196, 5.197
adding an implementation, 5.199, 5.200, 5.201
adding an item to a library, 5.198
command-line interface, 3.11
copying or renaming a unit test, 5.202
Create Unit Test wizard, 5.203
editing and running a unit test, 3.4
example, 3.12
exporting objects, 3.10
graphical user interface (GUI), 3.2
importing objects, 3.10
introduction and main topics, 3
library, 3.8
managing users, 5.204
overview, 3.1
renaming an implementation, 5.205
reports, 3.9
repository, 3.3
Synchronize Unit Test wizard, 5.207
tutorial, 3.12
variable substitution, 3.7
unloadiing
database objects, 5.73
unshared connection
preference for using on new worksheet, 1.18.5
unshared worksheet for a connection, 1.4, 1.7
unusable indexes, 1.3.12
updates
checking for SQL Developer updates, 5.6
Use All Oracle Database 12c Features in Migration option, 1.18.11
user information directory (IDE_USER_DIR), 1.19
user interface
restoring to original settings, 1.2.2
user interface (UI), 1.2, 2.3
unit testing, 3.2
user-defined extensions, 1.18.5
user-defined reports
chart example, 1.17.15.1
creating and editing, 5.60
dynamic HTML example, 1.17.15.2
explanation, 1.17.15
folders for, 1.17.15, 5.61
gauge example, 1.7.10
UserReports.xml, 1.17.15
user-defined snippets, 1.8.1
user-defined types
creating, 5.58
UserReports.xml, 1.17.15
users
creating and editing, 5.59
using, 1.11
UT_REPO_ADMINISTRATOR role, 3.3.1
UT_REPO_USER role, 3.3.1
ututil batch file or shell script, 3.11

V

variable substitution
unit testing, 3.7
versioning
preferences for, 1.18.15
SQL Developer support for, 1.10
viewlets
SQL Developer, 1.24
views, 1.3.33
compiling, 1.3.33
creating and editing, 5.62
FROM clause, 5.62
GROUP BY clause, 5.62
HAVING clause, 5.62
options when creating or editing, 5.62
ORDER BY clause, 5.62
recompiling, 1.3.33
SELECT clause, 5.62
splitting the data pane, 1.5
WHERE clause, 5.62

W

watches, 1.6.5
WHERE clause, 5.62

X

XML DB Repository, 1.3.34
XML schema, 1.3.35
creating, 5.63
xUnit frameworks, 3

Z

zero date handling
MySQL connections, 5.21