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

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