Skip Headers
Oracle® Database SQL Developer User's Guide
Release 1.1.2

Part Number B31695-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Beta Draft

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.41
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.61

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
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.60
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.66
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
database objects, 4.36
reports, 1.11
table data, 1.3.12, 4.37, 4.38
extensions, 4.40
SQL Developer, 1.12.7
user-defined, 1.12.4
external tables
properties, 4.22
external tools, 1.2.1, 4.39, 4.40

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.41
clearing, 1.2, 4.41
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.60
running, 4.60

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
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.60
running, 4.60
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.60
breakpoints, 4.61
running, 4.60
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.54
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.60

S

schema
XML, 1.3.17, 4.29
schema differences
differences between two schemas, 4.66
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.72
snippets, 1.9
user-defined, 1.9.1
source database
capturing, 2.6
source schema
schema differences, 4.66
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.76
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.60
running, 4.60
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.37, 4.38
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.39, 4.40
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