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.12.2

Access (Microsoft) connections, 4.5

Advanced Security for JDBC connection, 1.4

analyzing tables, 1.3.12

Apply Filter

to display of objects, 1.2, 4.42

associations

file types, 4.30

autocommit

preference for database connections, 1.12.4

autocomplete preferences, 1.2.1, 1.12.3

autotrace

Autotrace pane, 1.7.4

preferences for, 1.12.4

B

bind variables

for reports, 1.11

saving to disk on exit, 1.12.4

breakpoints

creating and editing, 4.63

C

character encoding

nonstandard (migrations on Windows), 2.4.3

charts

user-defined report example, 1.11.11.1

check constraints, 4.22

Check for Updates feature, 4.2

coalescing an index, 1.3.4

code fragments, 1.9

code insight, 1.12.3

column sequences, 4.22

columns

decrypting, 1.3.12

encrypting, 1.3.12

normalizing column data, 1.3.12

Compact option for shrinking a table, 1.3.12

compiling

function, 1.3.3

with debug, 1.3.3

procedure, 1.3.8

with debug, 1.3.8

view, 1.3.16

completion

SQL Developer preferences, 1.2.1, 1.12.3

completion insight, 1.12.3

configuring, 2.5.1

third-party databases, 2.5

configuring file type associations, 4.30

connections

creating, editing, or selecting, 4.5

explanation, 1.4

Microsoft Access, 4.5

Microsoft SQL Server, 4.5

MySQL, 4.5

Oracle Database, 4.5

constraints

check, 4.22

disabled, 1.11.3

unique, 4.22

converted model

correcting errors in, 2.7.1

creating and customizing, 2.7

custom export delimiter

preference for database connections, 1.12.4

customizing SQL Developer

setting preferences, 1.12

D

data

entering and modifying, 1.5

data types

creating, 4.24

database connections

creating, editing, or selecting, 4.5

explanation, 1.4

Microsoft Access, 4.5

Microsoft SQL Server, 4.5

MySQL, 4.5

Oracle Database, 4.5

database links, 1.3.1

creating or editing, 4.14

database objects, 1.3

exporting, 4.36

searching for, 1.10

DB Object Search pane, 1.10

DBMS_OUTPUT

user-defined report example, 1.11.11.2

DBMS_OUTPUT pane, 1.7.5

debugging PL/SQL function or procedure, 1.6

dialog box, 4.62

remote debugging, 1.6.1

decryption

data in a table column, 1.3.12

deployment

after database migration, 2.11

destination schema

schema differences, 4.68

dialog boxes and tabs, 4

directories (directory objects), 1.3.2

disabled constraints, 1.11.3

drivers

third-party JDBC, 1.12.4

dynamic HTML

user-defined report example, 1.11.11.2

E

encryption

data in a table column, 1.3.12

entering data in tables, 1.5

errors

parse exceptions, 2.7.1

Excel

importing data, 4.12

execution plan, 1.7.3

EXPLAIN PLAN

execution plan, 1.7.3

exporting

applying filters, 4.37

database objects, 4.36

reports, 1.11

table data, 1.3.12, 4.38, 4.39

extensions, 4.41

SQL Developer, 1.12.7

user-defined, 1.12.4

external tables

properties, 4.22

external tools, 1.2.1, 4.40, 4.41

F

F10 key

for File menu, 1.2

file types

associating with SQL Developer, 4.30

file-oriented development

SQL Worksheet right-click operations, 1.7

filter

applying, 1.2, 4.42

clearing, 1.2, 4.42

folders

for user-defined reports, 1.11.11, 4.27

foreign keys, 4.22

Freeze View

pinning an object's display, 1.2, 1.5, 1.11

FROM clause, 4.28

full pathname for java.exe, 1.1

functions

compiling, 1.3.3

compiling with debug, 1.3.3

creating, 4.18

debugging, 4.62

running, 4.62

G

Gather Schema Statistics menu command, 1.4

graphical user interface (GUI), 1.2, 2.13

GROUP BY clause, 4.28

H

HAVING clause, 4.28

help

PDF file containing online help, 1.14

using the online help, 1.14

HTML

dynamic (user-defined report), 1.11.11.2

I

identifier collection

PL/Scope, 1.4

importing

Excel data, 4.12

reports, 1.11

indexes, 4.22

coalescing, 1.3.4

creating or editing, 4.15

explanation, 1.3.4

making unusable, 1.3.4

rebuilding, 1.3.4

index-organized tables

properties, 4.22

introduction

SQL Developer, 1

J

java.exe

pathname for, 1.1

JDBC drivers, 1.12.4

K

keyboard shortcuts, 1.12.2

L

link

database, 4.14

LOB parameters, 4.22

locking a table, 1.3.12

lowercase characters in object names

quotation marks required, 4

M

materialized view logs, 1.3.6

creating and editing, 4.16

materialized views, 1.3.5

options when creating or editing, 4.28

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.5

Microsoft Excel

importing data, 4.12

Microsoft SQL Server, 2.5.1

creating data files, 2.9.1.1

third-party JDBC drivers, 1.12.4

Microsoft SQL Server connections, 4.5

migration

architecture, 2.2.1

before you start (general), 2.4

before you start (source-specific), 2.5

deployment after migrating, 2.11

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

moving a table to another tablespace, 1.3.12

MySQL

configuring before migrating, 2.5.3

creating data files, 2.9.1.3

third-party JDBC drivers, 1.12.4

MySQL connections, 4.5

zero date handling, 4.5

N

nonstandard character encoding on Windows

migration considerations, 2.4.3

normalizing

column data, 1.3.12

O

object search

DB Object Search pane, 1.10

objects

database, 1.3

exporting, 4.36

offline data transfer, 2.9.1

offline generation of Oracle DDL, 4.48

online help

PDF file containing, 1.14

using, 1.14

open SQL Worksheet automatically

preference for database connections, 1.12.4

Oracle Database connections, 4.5

Oracle ODBC data source

setting, 2.5.1

Oracle Web Agent (OWA), 1.7.6

ORDER BY clause, 4.28

overview

SQL Developer, 1

OWA_OUTPUT pane, 1.7.6

P

packages

creating, 4.17

debugging, 4.62

running, 4.62

parameter insight, 1.12.3

parse exception errors, 2.7.1

partitioned tables

partition definitions, 4.22

partitioning options, 4.22

subpartitioning options (templates), 4.22

pathname

for java.exe, 1.1

PDF file containing online help, 1.14

pinning an object's display, 1.2, 1.5, 1.11

PL/Scope

toggling identifier collection, 1.4

PL/SQL packages

creating, 4.17

PL/SQL subprograms

creating, 4.18

debugging, 4.62

breakpoints, 4.63

running, 4.62

plsql-dbms_output

user-defined report example, 1.11.11.2

preferences

customizing SQL Developer, 1.12

primary key, 4.22

private database links, 1.3.1

private synonyms, 1.3.11, 4.20

privileges

required for migration, 2.4.2

Probe debugger, 1.12.11

procedures

compiling, 1.3.8

compiling with debug, 1.3.8

creating, 4.18

projects

creating plan, 2.3.3

public database links, 1.3.1

public synonyms, 1.3.11, 4.20

Q

query builder, 4.56

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.4

recompiling

view, 1.3.16

Recycle bin, 1.3.9

remote debugging, 1.6.1

report navigator, 1.11

reports, 1.11

bind variables for, 1.11

exporting, 1.11

importing, 1.11

shared, 1.11

user-defined

chart example, 1.11.11.1

creating and editing, 4.26

dynamic HTML example, 1.11.11.2

explanation, 1.11.11

folders for, 1.11.11, 4.27

UserReports.xml, 1.11.11

roles

required for migration, 2.4.2

running PL/SQL function or procedure, 1.6

dialog box, 4.62

S

schema

XML, 1.3.17, 4.29

schema differences

differences between two schemas, 4.68

schema objects, 1.3

schema statistics

gathering, 1.4

scratch editor, 2.13.5

script runner, 1.7.2

scripts

running, 1.7.2

security

Advanced Security for JDBC connection, 1.4

SELECT clause, 4.28

sequences, 1.3.10

creating and editing, 4.19

for populating table columns, 4.22

shared reports, 1.11

shortcut keys

accelerator key mappings, 1.12.2

for menus, 1.2

shrinking a table, 1.3.12

single record view, 4.74

snippets, 1.9

user-defined, 1.9.1

source database

capturing, 2.6

source schema

schema differences, 4.68

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 Developer archive files, 1.13

SQL Developer preferences, 1.12

SQL scripts

running, 1.7.2

SQL Server

configuring, 2.5.1

creating data files, 2.9.1.1

third-party JDBC drivers, 1.12.4

SQL Server connections, 4.5

SQL Worksheet

opening automatically on database connection, 1.12.4

using, 1.7

SQL*Plus

location of executable, 4.78

location of executable (SQL Developer preference), 1.12.4, 1.12.12

using, 1.8

SQLDEVELOPER_USER_DIR location, 1.13

sqldevnnnnn.sql files (archive files), 1.13

statistics

computing table and column, 1.3.12

estimating table and column, 1.3.12

gathering schema, 1.4

storage options, 4.22

subpartitions

templates, 4.22

subprograms

creating, 4.18

debugging, 4.62

running, 4.62

substitution variables, 1.7.2

Sybase Adaptive Server

creating data files, 2.9.1.1

synonyms, 1.3.11

creating and editing, 4.20

T

tables, 1.3.12

analyzing, 1.3.12

compacting, 1.3.12

computing statistics, 1.3.12

creating and editing, 4.22

creating quickly, 4.21

decrypting column data, 1.3.12

encrypting column data, 1.3.12

entering and modifying data, 1.5

estimating statistics, 1.3.12

exporting data, 1.3.12, 4.38, 4.39

external

properties, 4.22

index-organized

properties, 4.22

locking, 1.3.12

moving to another tablespace, 1.3.12

normalizing column data, 1.3.12

partitioned

partition definitions, 4.22

partitioning options, 4.22

subpartitioning options (templates), 4.22

shrinking, 1.3.12

splitting the data pane, 1.5

temporary, 4.22

truncating, 1.3.12

validating structure, 1.3.12

tablespaces

considerations when migrating, 2.7.2.2

temporary tables, 4.22

third-party databases

configuring before migrating, 2.5

third-party JDBC drivers, 1.12.4

tnsnames.ora file, 1.4

Toggle PL/Scope Identifier Collection menu command, 1.4

tools

external, 1.2.1, 4.40, 4.41

transferring

data offline, 2.9.1

translation scratch editor, 2.13.5

triggers, 1.3.13

creating and editing, 4.23

truncating a table, 1.3.12

tutorial

creating objects for a small database, 3

types

creating, 4.24

U

unique constraints, 4.22

unusable indexes, 1.3.4

updates

checking for SQL Developer updates, 4.2

user information directory (SQLDEVELOPER_USER_DIR), 1.13

user interface (UI), 1.2, 2.13

user-defined extensions, 1.12.4

user-defined reports

chart example, 1.11.11.1

creating and editing, 4.26

dynamic HTML example, 1.11.11.2

explanation, 1.11.11

folders for, 1.11.11, 4.27

UserReports.xml, 1.11.11

user-defined snippets, 1.9.1

user-defined types

creating, 4.24

UserReports.xml, 1.11.11

users

creating and editing, 4.25

V

views, 1.3.16

compiling, 1.3.16

creating and editing, 4.28

FROM clause, 4.28

GROUP BY clause, 4.28

HAVING clause, 4.28

options when creating or editing, 4.28

ORDER BY clause, 4.28

recompiling, 1.3.16

SELECT clause, 4.28

splitting the data pane, 1.5

WHERE clause, 4.28

W

WHERE clause, 4.28

X

XML schema, 1.3.17

creating, 4.29

Z

zero date handling

MySQL connections, 4.5