Beta Draft

Index

A B C D E F G H I J K L M 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, 3.5

Advanced Security for JDBC connection, 1.4

analyzing tables, 1.3.12

Apply Filter

to display of objects, 1.2, 3.39

associations

file types, 3.28

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, 3.53

C

charts

user-defined report example, 1.11.11.1

check constraints, 3.20

Check for Updates feature, 3.2

coalescing an index, 1.3.4

code fragments, 1.9

code insight, 1.12.3

column sequences, 3.20

columns

decrypting, 1.3.12

encrypting, 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 file type associations, 3.28

connections

creating, editing, or selecting, 3.5

explanation, 1.4

Microsoft Access, 3.5

Microsoft SQL Server, 3.5

MySQL, 3.5

Oracle Database, 3.5

constraints

check, 3.20

disabled, 1.11.3

unique, 3.20

customizing SQL Developer

setting preferences, 1.12

D

data

entering and modifying, 1.5

data types

creating, 3.22

database connections

creating, editing, or selecting, 3.5

explanation, 1.4

Microsoft Access, 3.5

Microsoft SQL Server, 3.5

MySQL, 3.5

Oracle Database, 3.5

database links, 1.3.1

creating or editing, 3.12

database objects, 1.3

exporting, 3.34

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, 3.52

remote debugging, 1.6.1

decryption

data in a table column, 1.3.12

destination schema

schema differences, 3.58

dialog boxes and tabs, 3

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

execution plan, 1.7.3

EXPLAIN PLAN

execution plan, 1.7.3

exporting

database objects, 3.34

reports, 1.11

table data, 1.3.12, 3.35, 3.36

extensions, 3.38

SQL Developer, 1.12.7

user-defined, 1.12.4

external tables

properties, 3.20

external tools, 1.2.1, 3.37, 3.38

F

F10 key

for File menu, 1.2

file types

associating with SQL Developer, 3.28

file-oriented development

SQL Worksheet right-click operations, 1.7

filter

applying, 1.2, 3.39

clearing, 1.2, 3.39

folders

for user-defined reports, 1.11.11, 3.25

foreign keys, 3.20

Freeze View

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

FROM clause, 3.26

full pathname for java.exe, 1.1

functions

compiling, 1.3.3

compiling with debug, 1.3.3

creating, 3.16

debugging, 3.52

running, 3.52

G

Gather Schema Statistics menu command, 1.4

graphical user interface (GUI), 1.2

GROUP BY clause, 3.26

H

HAVING clause, 3.26

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

reports, 1.11

indexes, 3.20

coalescing, 1.3.4

creating or editing, 3.13

explanation, 1.3.4

making unusable, 1.3.4

rebuilding, 1.3.4

index-organized tables

properties, 3.20

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, 3.12

LOB parameters, 3.20

locking a table, 1.3.12

lowercase characters in object names

quotation marks required, 3

M

materialized view logs, 1.3.6

creating and editing, 3.14

materialized views, 1.3.5

options when creating or editing, 3.26

Microsoft Access connections, 3.5

Microsoft SQL Server

third-party JDBC drivers, 1.12.4

Microsoft SQL Server connections, 3.5

MOD_PLSQL

OWA output, 1.7.6

modifying data in tables, 1.5

moving a table to another tablespace, 1.3.12

MySQL

third-party JDBC drivers, 1.12.4

MySQL connections, 3.5

zero date handling, 3.5

O

object search

DB Object Search pane, 1.10

objects

database, 1.3

exporting, 3.34

online help

PDF file containing, 1.14

using, 1.14

open SQL Worksheet automatically

preference for database connections, 1.12.4

Oracle Database connections, 3.5

Oracle Web Agent (OWA), 1.7.6

ORDER BY clause, 3.26

overview

SQL Developer, 1

OWA_OUTPUT pane, 1.7.6

P

packages

creating, 3.15

debugging, 3.52

running, 3.52

parameter insight, 1.12.3

partitioned tables

partition definitions, 3.20

partitioning options, 3.20

subpartitioning options (templates), 3.20

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, 3.15

PL/SQL subprograms

creating, 3.16

debugging, 3.52

breakpoints, 3.53

running, 3.52

plsql-dbms_output

user-defined report example, 1.11.11.2

preferences

customizing SQL Developer, 1.12

primary key, 3.20

private database links, 1.3.1

private synonyms, 1.3.11, 3.18

Probe debugger, 1.12.10

procedures

compiling, 1.3.8

compiling with debug, 1.3.8

creating, 3.16

public database links, 1.3.1

public synonyms, 1.3.11, 3.18

Q

query builder, 3.50

quotation marks

for name with lowercase characters, special characters, or spaces, 3

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, 3.24

dynamic HTML example, 1.11.11.2

explanation, 1.11.11

folders for, 1.11.11, 3.25

UserReports.xml, 1.11.11

running PL/SQL function or procedure, 1.6

dialog box, 3.52

S

schema

XML, 1.3.17, 3.27

schema differences

differences between two schemas, 3.58

schema objects, 1.3

schema statistics

gathering, 1.4

script runner, 1.7.2

scripts

running, 1.7.2

security

Advanced Security for JDBC connection, 1.4

SELECT clause, 3.26

sequences, 1.3.10

creating and editing, 3.17

for populating table columns, 3.20

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, 3.61

snippets, 1.9

user-defined, 1.9.1

source schema

schema differences, 3.58

spaces in object names

quotation marks required, 3

special characters in object names

quotation marks required, 3

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

third-party JDBC drivers, 1.12.4

SQL Server connections, 3.5

SQL Worksheet

opening automatically on database connection, 1.12.4

using, 1.7

SQL*Plus

location of executable, 3.65

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

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, 3.20

subpartitions

templates, 3.20

subprograms

creating, 3.16

debugging, 3.52

running, 3.52

substitution variables, 1.7.2

synonyms, 1.3.11

creating and editing, 3.18

T

tables, 1.3.12

analyzing, 1.3.12

compacting, 1.3.12

computing statistics, 1.3.12

creating and editing, 3.20

creating quickly, 3.19

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, 3.35, 3.36

external

properties, 3.20

index-organized

properties, 3.20

locking, 1.3.12

moving to another tablespace, 1.3.12

partitioned

partition definitions, 3.20

partitioning options, 3.20

subpartitioning options (templates), 3.20

shrinking, 1.3.12

splitting the data pane, 1.5

temporary, 3.20

truncating, 1.3.12

temporary tables, 3.20

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, 3.37, 3.38

triggers, 1.3.13

creating and editing, 3.21

truncating a table, 1.3.12

tutorial

creating objects for a small database, 2

types

creating, 3.22

U

unique constraints, 3.20

unusable indexes, 1.3.4

updates

checking for SQL Developer updates, 3.2

user information directory (SQLDEVELOPER_USER_DIR), 1.13

user interface (UI), 1.2

user-defined extensions, 1.12.4

user-defined reports

chart example, 1.11.11.1

creating and editing, 3.24

dynamic HTML example, 1.11.11.2

explanation, 1.11.11

folders for, 1.11.11, 3.25

UserReports.xml, 1.11.11

user-defined snippets, 1.9.1

user-defined types

creating, 3.22

UserReports.xml, 1.11.11

users

creating and editing, 3.23

V

views, 1.3.16

compiling, 1.3.16

creating and editing, 3.26

FROM clause, 3.26

GROUP BY clause, 3.26

HAVING clause, 3.26

options when creating or editing, 3.26

ORDER BY clause, 3.26

recompiling, 1.3.16

SELECT clause, 3.26

splitting the data pane, 1.5

WHERE clause, 3.26

W

WHERE clause, 3.26

X

XML schema, 1.3.17

creating, 3.27

Z

zero date handling

MySQL connections, 3.5