10/10

# 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.43
  associations
    file types, 4.31
  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.64

## C

  character encoding
    nonstandard (migrations on Windows), 2.4.3
  charts
    user-defined report example, 1.11.11.1
  check constraints, 4.23
  Check for Updates feature, 4.2
  coalescing an index, 1.3.4
  code fragments, 1.9
  code insight, 1.12.3
  column sequences, 4.23
  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.31
  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.23
    disabled, 1.11.3
    unique, 4.23
  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.25
  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.37
    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.63
    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.69
  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.38
    database objects, 4.37
    reports, 1.11
    table data, 1.3.12, 4.39, 4.40
  extensions, 4.42
    SQL Developer, 1.12.7
    user-defined, 1.12.4
  external tables
    properties, 4.23
  external tools, 1.2.1, 4.41, 4.42

## F

  F10 key
    for File menu, 1.2
  file types
    associating with SQL Developer, 4.31
  file-oriented development
    SQL Worksheet right-click operations, 1.7
  filter
    applying, 1.2, 4.43
    clearing, 1.2, 4.43
  folders
    for user-defined reports, 1.11.11, 4.28
  foreign keys, 4.23
  Freeze View
    pinning an object's display, 1.2, 1.5, 1.11
  FROM clause, 4.29
  full pathname for java.exe, 1.1
  functions
    compiling, 1.3.3
    compiling with debug, 1.3.3
    creating, 4.18
    debugging, 4.63
    running, 4.63

## G

  Gather Schema Statistics menu command, 1.4
  graphical user interface (GUI), 1.2, 2.13
  GROUP BY clause, 4.29

## H

  HAVING clause, 4.29
  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.23
    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.23
  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.23
  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.29
  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.37
  offline data transfer, 2.9.1
  offline generation of Oracle DDL, 4.49
  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.29
  overview
    SQL Developer, 1
  OWA_OUTPUT pane, 1.7.6

## P

  packages
    creating, 4.17
    debugging, 4.63
    running, 4.63
  parameter insight, 1.12.3
  parse exception errors, 2.7.1
  partitioned tables
    partition definitions, 4.23
    partitioning options, 4.23
    subpartitioning options (templates), 4.23
  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.63
      breakpoints, 4.64
    running, 4.63
  plsql-dbms_output
    user-defined report example, 1.11.11.2
  preferences
    customizing SQL Developer, 1.12
  primary key, 4.23
  private database links, 1.3.1
  private synonyms, 1.3.11, 4.21
  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.21

## Q

  query builder, 4.57
  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.27
      dynamic HTML example, 1.11.11.2
      explanation, 1.11.11
      folders for, 1.11.11, 4.28
      UserReports.xml, 1.11.11
  roles
    required for migration, 2.4.2
  running PL/SQL function or procedure, 1.6
    dialog box, 4.63

## S

  schema
    XML, 1.3.17, 4.30
  schema differences
    differences between two schemas, 4.69
  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.29
  sequences, 1.3.10
    creating and editing, 4.19
    for populating table columns, 4.23
  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.75
  snippets, 1.9
    user-defined, 1.9.1
  source database
    capturing, 2.6
  source schema
    schema differences, 4.69
  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 file
    creating, 4.20
  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.79
    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.23
  subpartitions
    templates, 4.23
  subprograms
    creating, 4.18
    debugging, 4.63
    running, 4.63
  substitution variables, 1.7.2
  Sybase Adaptive Server
    creating data files, 2.9.1.1
  synonyms, 1.3.11
    creating and editing, 4.21

## T

  tables, 1.3.12
    analyzing, 1.3.12
    compacting, 1.3.12
    computing statistics, 1.3.12
    creating and editing, 4.23
    creating quickly, 4.22
    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.39, 4.40
    external
      properties, 4.23
    index-organized
      properties, 4.23
    locking, 1.3.12
    moving to another tablespace, 1.3.12
    normalizing column data, 1.3.12
    partitioned
      partition definitions, 4.23
      partitioning options, 4.23
      subpartitioning options (templates), 4.23
    shrinking, 1.3.12
    splitting the data pane, 1.5
    temporary, 4.23
    truncating, 1.3.12
    validating structure, 1.3.12
  tablespaces
    considerations when migrating, 2.7.2.2
  temporary tables, 4.23
  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.41, 4.42
  transferring
    data offline, 2.9.1
  translation scratch editor, 2.13.5
  triggers, 1.3.13
    creating and editing, 4.24
  truncating a table, 1.3.12
  tutorial
    creating objects for a small database, 3
  types
    creating, 4.25

## U

  unique constraints, 4.23
  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.27
    dynamic HTML example, 1.11.11.2
    explanation, 1.11.11
    folders for, 1.11.11, 4.28
    UserReports.xml, 1.11.11
  user-defined snippets, 1.9.1
  user-defined types
    creating, 4.25
  UserReports.xml, 1.11.11
  users
    creating and editing, 4.26

## V

  views, 1.3.16
    compiling, 1.3.16
    creating and editing, 4.29
    FROM clause, 4.29
    GROUP BY clause, 4.29
    HAVING clause, 4.29
    options when creating or editing, 4.29
    ORDER BY clause, 4.29
    recompiling, 1.3.16
    SELECT clause, 4.29
    splitting the data pane, 1.5
    WHERE clause, 4.29

## W

  WHERE clause, 4.29

## X

  XML schema, 1.3.17
    creating, 4.30

## Z

  zero date handling
    MySQL connections, 4.5