Skip Headers
Oracle® SQL Developer User's Guide
Release 4.0

E38414-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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.20.11
accelerator (shortcut) keys, 1.20.13
for menus, 1.2
Access (Microsoft) connections, 5.29
Active Session History (ASH) reports, 1.19.4
Advanced Security for JDBC connection, 1.4.3
analyzing tables, 1.3.29
application
deploying (Application Express), 5.86
importing (Application Express), 5.86
Application Express
applications, 1.3.1
deploying an application, 5.86
importing an application, 5.86
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.109
ASH (Active Session History) reports, 1.19.4
associations
file types, 5.14
AST (abstract syntax tree), 1.20.11
authentication
Kerberos, 5.29
Database Advanced Parameters, 1.20.5
OS (operating system), 5.29
autocommit
preference for database connections, 1.20.5
autocomplete preferences, 1.20.3
autogenerated connections, 1.4
Auto-Generated connections folder, 1.4
Automated Workload Repository (AWR) reports, 1.19.4
autotrace
Autotrace pane, 1.7.4
preferences for, 1.20.5
AWR (Automated Workload Repository) reports, 1.19.4

B

bequeath connection type, 5.29
Berkeley DB
data storage for Subversion repository, 5.223
bind variables
for reports, 1.19
saving to disk on exit, 1.20.5
blogs
SQL Developer, 1.28
border color associated with connection, 5.29
breakpoints
creating and editing, 5.194

C

cache groups, 1.3.2
cart
command-line interface, 1.23
Cart (SQL Developer), 1.14
case insensitivity for queries
setting, 2.2.9
CDB
definition, 1.3.18
chains (Scheduler), 1.3.3
creating and editing, 5.26
Change case as you type
completion insight option, 1.20.3
charts
user-defined report example, 1.19.15.1
check constraints, 5.64
Check for Updates feature, 5.8
CLOBtoBLOB_sqldeveloper stored procedure, 1.20.11
close all SQL Worksheets automatically on disconnect
preference for database connections, 1.20.5
clustered primary keys (Sybase)
generating as Oracle index-organized tables, 1.20.11
clustered unique indexes (Sybase)
generating as Oracle index-organized tables, 1.20.11
coalescing an index, 1.3.12
code coverage
gathering and viewing statistics, 3.4
code fragments, 1.8
code insight (completion insight), 1.20.3
column sequences, 5.64
columns
decrypting, 1.3.29
encrypting, 1.3.29
normalizing column data, 1.3.29
command line interface to SQL Developer, 1.23
command-line interface, 1.23
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.20.3
completion insight, 1.20.3
compound triggers, 1.20.11
configuring, 2.2.4.2, 2.2.4.2
third-party databases, 2.2.4
configuring file type associations, 5.14
connection color, 5.29
connections
creating, editing, or selecting, 5.29
explanation, 1.4
Hive, 5.29
IBM DB2, 5.29
JDBC, 5.29
Microsoft Access, 5.29
Microsoft SQL Server, 5.29
MySQL, 5.29
Oracle Database, 5.29
Oracle TimesTen, 5.29
PostgreSQL, 5.29
separate unshared connection preference, 1.20.5
separate unshared worksheet for, 1.4, 1.7
Sybase Adaptive Server, 5.29
Teradata, 5.29
using folders to group, 1.4.1
constraints
check, 5.64
disabled, 1.19.12
unique, 5.64
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.255
create users option (migration generation options), 1.20.11
credentials (Scheduler), 1.3.4
creating and editing, 5.27
crossedition triggers, 1.3.30
customizing SQL Developer
setting preferences, 1.20
CVS (Concurrent Versions System)
preferences for, 1.20.16
SQL Developer support for, 1.11

D

data
entering and modifying, 1.5
Data Modeler
included in SQL Developer, 1.24
data move
number of parallel streams, 1.20.11
options, 1.20.11
Data Pump Export wizard, 5.79
Data Pump Import wizard, 5.80
data redaction, 1.3.29
data types
creating, 5.68
database administrator (DBA) features in SQL Developer, 1.12
database connections, 5.29
creating, editing, or selecting, 5.29
explanation, 1.4
Hive, 5.29
IBM DB2, 5.29
JDBC, 5.29
Microsoft Access, 5.29
Microsoft SQL Server, 5.29
MySQL, 5.29
Oracle Database, 5.29
Oracle TimesTen, 5.29
PostgreSQL, 5.29
Sybase Adaptive Server, 5.29
Teradata, 5.29
database destination groups (Scheduler), 1.3.7
creating and editing, 5.46, 5.46
database destinations (Scheduler), 1.3.5
creating and editing, 5.45
database links, 1.3.6
creating or editing, 5.47
database objects, 1.3
exporting, 5.83
finding (searching for), 1.9
recent, 1.10
unloadiing, 5.83
database schema differences
differences between two database schemas, 5.82, 5.89
DB2
before migrating, 2.2.4.1
DB2 (IBM) connections, 5.29
DBA features in SQL Developer
using, 1.12
DBMS_OUTPUT
user-defined report example, 1.19.15.2
DBMS_OUTPUT pane, 1.7.5
debugging PL/SQL function or procedure, 1.6
dialog box, 5.193
remote debugging, 1.6.2
decryption
data in a table column, 1.3.29
default password
Use Default Password connection option, 5.29
deploying objects using the Cart, 1.14
deployment
after database migration, 2.2.11
destination groups (Scheduler), 1.3.7
creating and editing, 5.46
destination schema
database schema differences, 5.82, 5.89
destinations
database (Scheduler), 1.3.5
dialog boxes and tabs, 5
diff
command-line interface, 1.23
directories (directory objects), 1.3.8
disabled constraints, 1.19.12
discussion forum
SQL Developer, 1.28
documentation
generating for schema, 1.4
downloads
SQL Developer, 1.28
drag and drop effects, 1.20.5
drivers
third-party JDBC, 1.20.5
dynamic HTML
user-defined report example, 1.19.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.20.11
Enable Semantic Analysis Info Tip, 1.20.3
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.43
execution plan, 1.7.3
expired password
resetting, 1.4
EXPLAIN PLAN
execution plan, 1.7.3
export
command-line interface, 1.23
exporting
database objects, 5.83
reports, 1.19
table data, 1.3.29, 5.95
unit test objects, 3.10
expression watches, 1.6.5
extensions, 5.101
loading, 5.144
SQL Developer, 1.20.7
user-defined, 1.20.5
external destination groups (Scheduler), 1.3.7
external editor
SQL Developer preferences, 1.20.8
external tables
properties, 5.64
external tools, 1.2.1, 5.100, 5.101

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.20.11
file types
associating with SQL Developer, 5.14
file watchers (Scheduler), 1.3.10
creating and editing, 5.49
file-oriented development
SQL Worksheet right-click operations, 1.7
Files navigator, 1.2
filter
applying, 1.2, 5.109
clearing, 1.2, 5.109
finding database objects, 1.9
Flashback Table support, 1.3.29.1
folders
for user-defined reports, 1.19.15, 5.71
in Connections navigator, 1.4.1
font
increasing or decreasing size for help text, 1.26
foreign keys, 5.64
formatter
command-line interface, 1.7.9, 1.23
Freeze View
pinning an object’s display, 1.2, 1.5, 1.19
FROM clause, 5.72
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.51
debugging, 5.193
running, 5.193

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.11
Generate DB Doc menu command, 1.4
generate failed objects option, 1.20.11
generate separate emulation user option, 1.20.11
Git
preferences for, 1.20.16
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.72
groups
connections in folders, 1.4.1

H

HAVING clause, 5.72
help
increasing or decreasing help text font size, 1.26
using the online help, 1.26
hierarchical profiler (PL/SQL), 1.6.4
Hive connections, 5.29
HTML
dynamic (user-defined report), 1.19.15.2

I

IBM DB2
before migrating, 2.2.4.1
IBM DB2 connections, 5.29
IDE_USER_DIR location, 1.21
implementation
adding for a unit test, 5.251, 5.252, 5.253
renaming for a unit test, 5.257
import
command-line interface, 1.23
importing
Microsoft Excel data, 5.43
reports, 1.19
unit test objects, 3.10
indexes, 5.64
coalescing, 1.3.12
creating or editing, 5.48
explanation, 1.3.12
making unusable, 1.3.12
rebuilding, 1.3.12
index-organized tables
properties, 5.64
introduction
SQL Developer, 1

J

Java sources, 1.3.13
java.exe
pathname for, 1.1
JDBC connections, 5.29
JDBC drivers, 1.20.5
JDK location
specified in product.conf, 1.22
job classes (Scheduler), 1.3.15
creating and editing, 5.53
job scheduler
using in SQL Developer, 1.13
jobs
scheduling using SQL Developer, 1.13
jobs (Scheduler), 1.3.14
creating and editing, 5.52
jTDS
JDBC driver for Microsoft SQL Server and Sybase Adaptive Server, 1.20.5

K

Kerberos authentication, 5.29
Database Advanced Parameters, 1.20.5
keyboard shortcuts, 1.20.13

L

least privilege schema migration, 1.20.11
library
adding an item for unit testing, 5.250
unit testing, 3.8
link
database, 5.47
Load Extension, 5.144
LOB parameters, 5.64
local connections
creating, 1.4
locking a table, 1.3.29
lookups
adding for unit testing, 5.248, 5.249
lowercase characters in object names
quotation marks required, 5

M

materialized view logs, 1.3.17
creating and editing, 5.54
materialized views, 1.3.16
options when creating or editing, 5.72
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.29
Microsoft Excel
importing data, 5.43
Microsoft SQL Server, 2.2.4.2
connections, 5.29
creating data files, 2.2.8.1.1
third-party JDBC drivers, 1.20.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, 1.23, 1.23
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 plan
preparing, 2.2.2
migration repository
creating database user for, 2.2.3.1
MIME type
specifying external editor for BLOB data, 1.20.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.20.5
MySQL connections, 5.29
zero date handling, 5.29

N

navigation tree filtering option, 1.20.5
New Worksheet to use unshared connection
preference for database SQL Worksheet
using unshared connection automatically, 1.20.5
normalizing
column data, 1.3.29

O

OBEs (Oracle By Example lessons), 1.28
objects
database, 1.3
exporting, 5.83
unloadiing, 5.83
OCI driver
database advanced parameters preference, 1.20.5
offline data transfer, 2.2.8.1
OLAP DML statements
entering in SQL Worksheet, 1.7.12
online help
using, 1.26
Open command on Connections navigator context menu
open SQL Worksheet automatically
preference for database connections, 1.20.5
operating system authentication, 5.29
ORA_ROWSCN pseudocolumn
"Use ORA_ROWSCN for DataEditor insert and update statements" preference, 1.20.5
Oracle Application Express
applications, 1.3.1
Oracle By Example (OBE) lessons, 1.28
Oracle Database 12c features
generating in migration, 1.20.11
Oracle Database connections, 5.29
Oracle Web Agent (OWA), 1.7.6
ORDER BY clause, 5.72
OS authentication, 5.29
OTN page
SQL Developer, 1.28
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.55
debugging, 5.193
running, 5.193
parallel data move streams, 1.20.11
parameter insight, 1.20.3
parse exception errors, 2.2.6.1
partitioned tables
partition definitions, 5.64
partitioning options, 5.64
subpartitioning options (templates), 5.64
password
resetting expired, 1.4
pathname
for java.exe, 1.1
PDB
definition, 1.3.18
Perforce
preferences for, 1.20.16
pinning an object’s display, 1.2, 1.5, 1.19
PL/SQL hierarchical profiler, 1.6.4
PL/SQL packages
creating, 5.55
PL/SQL subprograms
debugging, 5.193
breakpoints, 5.194
running, 5.193
plsql-dbms_output
user-defined report example, 1.19.15.2
pluggable database (PDB)
definition, 1.3.18
pluggable databases
cloning, 5.11
creating, 5.56, 5.152
dropping, 5.90
plugging in, 5.174
unplugging, 5.260
PostgreSQL
connections, 5.29
third-party JDBC drivers, 1.20.5
preferences
customizing SQL Developer, 1.20
preferences (options), 1.20.14
primary key, 5.64
private database links, 1.3.6
private synonyms, 1.3.28, 5.62
privileges
required for migration, 2.2.3.2
procedures
creating, 5.51
product.conf file, 1.22
profiler (PL/SQL hierarchical), 1.6.4
profiling a PL/SQL function or procedure, 5.193
programs (Scheduler), 1.3.21
creating and editing, 5.57
projects
creating plan, 2.2.2.3
proxy authentication, 1.4.5
proxy connections, 1.4.5, 5.29
public database links, 1.3.6
public synonyms, 1.3.28, 5.62
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
recent objects, 1.10
recompiling
view, 1.3.33
Recycle bin, 1.3.24
redaction, 1.3.29
refactor in bulk, 1.3.1
remote debugging, 1.6.2
replication schemes, 1.3.25
report navigator, 1.19
reports, 1.19
bind variables for, 1.19
exporting, 1.19
importing, 1.19
shared, 1.19
unit testing, 3.9
user-defined
chart example, 1.19.15.1
creating and editing, 5.70
dynamic HTML example, 1.19.15.2
explanation, 1.19.15
folders for, 1.19.15, 5.71
gauge example, 1.7.11
UserReports.xml, 1.19.15
repository
unit test, 3.3
Reset Password menu command, 1.4
resource handler, 1.18.2
creating, 5.185.3
resource module, 1.18.2
resource template, 1.18.2
creating, 5.185.2
REST Data Services administration, 1.17
RESTful service module
creating, 5.185.1
roles
creating and editing, 5.58
required for migration, 2.2.3.2
running PL/SQL function or procedure, 1.6
dialog box, 5.193

S

scheduler
using in SQL Developer, 1.13
schedules (Scheduler), 1.3.26
creating and editing, 5.59
scheduling jobs in SQL Developer, 1.13
schema
XML, 1.3.37, 5.75, 5.76
schema differences
differences between two database schemas, 5.82, 5.89
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
Secure Shell (SSH)
authentication, 1.4.6
connections, 1.4.6
security
Advanced Security for JDBC connection, 1.4.3
SELECT clause, 5.72
Semantic Analysis Info Tip
enabling, 1.20.3
sequences, 1.3.27
creating and editing, 5.60
for populating table columns, 5.64
sessions
monitoring, 1.2.1
SetJavaHome line in product.conf file, 1.22
shared reports, 1.19
shared repository, 3.3
shortcut keys, 1.20.13
for menus, 1.2
restoring to default scheme, 1.20.13
shrinking a table, 1.3.29
single record view, 5.209
size of help text
increasing or decreasing, 1.26
snippets, 1.8
user-defined, 1.8.1
source database
capturing, 2.2.5
source schema
database schema differences, 5.82, 5.89
spaces in object names
quotation marks required, 5
Spatial support
Maintain Spatial Metadata dialog box, 5.147
Validate Geometry dialog box, 5.262
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.20
SQL file
creating, 5.61
SQL formatting
command-line interface, 1.7.9, 1.23
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.20.5
SQL Server connections, 5.29
SQL Trace files (.trc), 1.6.3
SQL Worksheet
closing automatically on disconnect, 1.20.5
entering OLAP DML statements, 1.7.12
opening automatically on database connection, 1.20.5
unshared for a connection, 1.4, 1.7
using, 1.7
SSH
authentication, 1.4.6
connections, 1.4.6
Start Page for SQL Developer, 1.28
statistics
computing table and column, 1.3.29
estimating table and column, 1.3.29
gathering schema, 1.4
storage options, 5.65
stored procedures
generating for Migrate Blobs Offline, 1.20.11
subpartitions
templates, 5.64
subprograms
creating, 5.51
debugging, 5.193
running, 5.193
substitution variables, 1.7.2
Subversion
preferences for, 1.20.16
SQL Developer support for, 1.11
Sybase Adaptive Server, 2.2.4.2
connections, 5.29
creating data files, 2.2.8.1.1
third-party JDBC drivers, 1.20.5
Sybase clustered primary keys
generating as Oracle index-organized tables, 1.20.11
Sybase clustered unique indexes
generating as Oracle index-organized tables, 1.20.11
Synchronize Unit Test wizard, 5.259
synonyms, 1.3.28
creating and editing, 5.62

T

tables, 1.3.29
analyzing, 1.3.29
compacting, 1.3.29
computing statistics, 1.3.29
creating and editing, 5.64
creating quickly, 5.63
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.95
external
properties, 5.64
index-organized
properties, 5.64
locking, 1.3.29
moving to another tablespace, 1.3.29
normalizing column data, 1.3.29
partitioned
partition definitions, 5.64
partitioning options, 5.64
subpartitioning options (templates), 5.64
shrinking, 1.3.29
splitting the data pane, 1.5
temporary, 5.64
truncating, 1.3.29
validating structure, 1.3.29
tablespaces
creating and editing, 5.66
Target Oracle Database 12c features in migration option, 1.20.11
temporary tables, 5.64
Teradata
before migrating, 2.2.4.5
connections, 5.29
test case
definition of, 3.1
test suite
definition of, 3.1
thick (OCI) driver
database advanced parameters preference, 1.20.5
third-party databases
configuring before migrating, 2.2.4
third-party JDBC drivers, 1.20.5
TimesTen
cache groups, 1.3.2
database connections, 5.29
replication schemes, 1.3.25
support for in SQL Developer, 1.25
Tip of the Day, 1.27
TKPROF
opening in SQL Developer as an alternative to using, 1.6.3
tnsnames.ora file, 1.4
tools
external, 1.2.1, 5.100, 5.101
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.20.11
creating and editing, 5.67
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.68

U

unique constraints, 5.64
unit test
definition of (as related to test cases), 3.1
unit testing, 1.20.14
adding a category for lookups, 5.248, 5.249
adding an implementation, 5.251, 5.252, 5.253
adding an item to a library, 5.250
best practices, 3.12
command-line interface, 1.23, 3.11
copying or renaming a unit test, 5.254
Create Unit Test wizard, 5.255
editing and running a unit test, 3.4
example, 3.13
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.256
overview, 3.1
renaming an implementation, 5.257
reports, 3.9
repository, 3.3
Synchronize Unit Test wizard, 5.259
tutorial, 3.13
variable substitution, 3.7
unloadiing
database objects, 5.83
unshared connection
preference for using on new worksheet, 1.20.5
unshared worksheet for a connection, 1.4, 1.7
unusable indexes, 1.3.12
updates
checking for SQL Developer updates, 5.8
URI template, 1.18.2
usage suggestions, 1.27
Use Default Password connection option, 5.29
Use Windows Authentication connection option, 5.29
user information directory (IDE_USER_DIR), 1.21
user interface
restoring to original settings, 1.2.2
user interface (UI), 1.2, 2.3
unit testing, 3.2
user-defined extensions, 1.20.5
user-defined reports
chart example, 1.19.15.1
creating and editing, 5.70
dynamic HTML example, 1.19.15.2
explanation, 1.19.15
folders for, 1.19.15, 5.71
gauge example, 1.7.11
UserReports.xml, 1.19.15
user-defined snippets, 1.8.1
user-defined types
creating, 5.68
UserReports.xml, 1.19.15
users
creating and editing, 5.69
using, 1.12
UT_REPO_ADMINISTRATOR role, 3.3.1
UT_REPO_USER role, 3.3.1

V

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

W

watches, 1.6.5
WHERE clause, 5.72
window groups (Scheduler), 1.3.34
creating and editing, 5.74
windows (Scheduler), 1.3.35
creating and editing, 5.73
Windows authentication
Use Windows Authentication connection option, 5.29

X

XML DB Repository, 1.3.36
XML schema, 1.3.37
creating, 5.75, 5.76
xUnit frameworks, 3

Z

zero date handling
MySQL connections, 5.29