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