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.13.2
  Access (Microsoft) connections, 4.12
  Active Session History (ASH) reports, 1.12.4
  Advanced Security for JDBC connection, 1.4.3
  analyzing tables, 1.3.18
  application
    deploying (Application Express), 4.54
    importing (Application Express), 4.54
  Application Express
    applications, 1.3.1
    deploying an application, 4.54
    importing an application, 4.54
    Publish to Apex option, 1.5
    starting and stopping EPG (embedded PL/SQL gateway), 1.3.1
  applications
    Application Express, 1.3.1
  Apply Filter
    to display of objects, 1.2, 4.68
  ASH (Active Session History) reports, 1.12.4
  associations
    file types, 4.48
  authentication
    Kerberos, 4.12
      Database Advanced Parameters, 1.13.5
    OS (operating system), 4.12
  autocommit
    preference for database connections, 1.13.5
  autocomplete preferences, 1.13.3
  autocompletion
    Source menu, 1.2.1
  Automated Workload Repository (AWR) reports, 1.12.4
  autotrace
    Autotrace pane, 1.7.4
    preferences for, 1.13.5
  AWR (Automated Workload Repository) reports, 1.12.4

## B

  Berkeley DB
    data storage for Subversion repository, 4.35
  bind variables
    for reports, 1.12
    saving to disk on exit, 1.13.5
  blogs
    SQL Developer, 1.17
  breakpoints
    creating and editing, 4.106

## C

  cache groups, 1.3.2
  case insensitivity for queries
    setting, 2.10
  charts
    user-defined report example, 1.12.15.1
  check constraints, 4.38
  Check for Updates feature, 4.3
  CLOBtoBLOB_sqldeveloper stored procedure, 1.13.10
  close all SQL Worksheets automatically on disconnect
    preference for database connections, 1.13.5
  coalescing an index, 1.3.6
  code completion
    Source menu, 1.2.1
  code fragments, 1.8
  code insight, 1.13.3
  column sequences, 4.38
  columns
    decrypting, 1.3.18
    encrypting, 1.3.18
    normalizing column data, 1.3.18
  Compact option for shrinking a table, 1.3.18
  compiling
    function, 1.3.5
      for debug, 1.3.5
    procedure, 1.3.11
      for debug, 1.3.11
    view, 1.3.22
  completion
    SQL Developer preferences, 1.13.3
  completion insight, 1.13.3
    Source menu, 1.2.1
  configuring, 2.5.1, 2.5.1
    third-party databases, 2.5
  configuring file type associations, 4.48
  connections
    creating, editing, or selecting, 4.12
    explanation, 1.4
    Microsoft Access, 4.12
    Microsoft SQL Server, 4.12
    MySQL, 4.12
    Oracle Database, 4.12
    Oracle TimesTen, 4.12
    separate unshared worksheet for, 1.4, 1.7
    Sybase Adaptive Server, 4.12
    using folders to group, 1.4.1
  constraints
    check, 4.38
    disabled, 1.12.12
    unique, 4.38
  converted model
    correcting errors in, 2.7.1
    creating and customizing, 2.7
  custom export delimiter
    preference for database connections, 1.13.5
  customizing SQL Developer
    setting preferences, 1.13
  CVS (Concurrent Versions System)
    preferences for, 1.13.11
    SQL Developer support for, 1.11

## D

  data
    entering and modifying, 1.5
  data move
    generating user, 1.13.10
    number of parallel streams, 1.13.10
    options, 1.13.10
  data types
    creating, 4.41
  database connections, 4.12
    creating, editing, or selecting, 4.12
    explanation, 1.4
    Microsoft Access, 4.12
    Microsoft SQL Server, 4.12
    MySQL, 4.12
    Oracle Database, 4.12
    Oracle TimesTen, 4.12
    Sybase Adaptive Server, 4.12
  database links, 1.3.3
    creating or editing, 4.25
  database objects, 1.3
    exporting, 4.59
    searching for, 1.9
  database schema differences
    differences between two database schemas, 4.51
  DB Object Search pane, 1.9
  DBMS_OUTPUT
    user-defined report example, 1.12.15.2
  DBMS_OUTPUT pane, 1.7.5
  debugging PL/SQL function or procedure, 1.6
    dialog box, 4.105
    remote debugging, 1.6.2
  decryption
    data in a table column, 1.3.18
  deployment
    after database migration, 2.12
  destination schema
    database schema differences, 4.51
  dialog boxes and tabs, 4
  directories (directory objects), 1.3.4
  disabled constraints, 1.12.12
  discussion forum
    SQL Developer, 1.17
  documentation
    generating for schema, 1.4
  downloads
    SQL Developer, 1.17
  drag and drop effects, 1.13.5
  drivers
    third-party JDBC, 1.13.5
  dynamic HTML
    user-defined report example, 1.12.15.2

## E

  embedded PL/SQL gateway (EPG) for Application Express
    starting and stopping, 1.3.1
  encryption
    data in a table column, 1.3.18
  entering data in tables, 1.5
  EPG (embedded PL/SQL gateway) for Application Express
    starting and stopping, 1.3.1
  errors
    parse exceptions, 2.7.1
  Excel
    importing data, 4.23
  execution plan, 1.7.3
  EXPLAIN PLAN
    execution plan, 1.7.3
  exporting
    applying filters, 4.60
    database objects, 4.59
    reports, 1.12
    table data, 1.3.18, 4.61, 4.62
  expression watches, 1.6.5
  extended search, 1.10
  extensions, 4.65
    SQL Developer, 1.13.7
    user-defined, 1.13.5
  external tables
    properties, 4.38
  external tools, 1.2.1, 4.64, 4.65

## F

  F10 key
    for File menu, 1.2
  F4 key, 1.7
  failed objects
    generating, 1.13.10
  file types
    associating with SQL Developer, 4.48
  file-oriented development
    SQL Worksheet right-click operations, 1.7
  Files navigator, 1.2
  filter
    applying, 1.2, 4.68
    clearing, 1.2, 4.68
  Find DB Object pane, 1.9
  Flashback Table support, 1.3.18.1
  folders
    for user-defined reports, 1.12.15, 4.44
    in Connections navigator, 1.4.1
  font
    increasing or decreasing size for help text, 1.16
  foreign keys, 4.38
  Freeze View
    pinning an object’s display, 1.2, 1.5, 1.12
  FROM clause, 4.45
  full pathname for java.exe, 1.1
  functions
    compiling, 1.3.5
    compiling for debug, 1.3.5
    creating, 4.30
    debugging, 4.105
    running, 4.105

## G

  Gather Schema Statistics menu command, 1.4
  gauges
    in SQL Worksheet and user-defined reports, 1.7.8
  generate data move user option, 1.13.10
  Generate DB Doc menu command, 1.4
  generate failed objects option, 1.13.10
  graphical user interface (GUI), 1.2, 2.14
  GROUP BY clause, 4.45
  groups
    connections in folders, 1.4.1

## H

  HAVING clause, 4.45
  help
    increasing or decreasing help text font size, 1.16
    using the online help, 1.16
  hierarchical profiler (PL/SQL), 1.6.4
  HTML
    dynamic (user-defined report), 1.12.15.2

## I

  importing
    Microsoft Excel data, 4.23
    reports, 1.12
  indexes, 4.38
    coalescing, 1.3.6
    creating or editing, 4.26
    explanation, 1.3.6
    making unusable, 1.3.6
    rebuilding, 1.3.6
  index-organized tables
    properties, 4.38
  introduction
    SQL Developer, 1

## J

  Java sources, 1.3.7
  java.exe
    pathname for, 1.1
  JDBC drivers, 1.13.5
  jTDS
    JDBC driver for Microsoft SQL Server and Sybase Adaptive Server, 1.13.5

## K

  Kerberos authentication, 4.12
    Database Advanced Parameters, 1.13.5
  keyboard shortcuts, 1.13.2

## L

  least privilege schema migration, 1.13.10
  link
    database, 4.25
  LOB parameters, 4.38
  locking a table, 1.3.18
  lowercase characters in object names
    quotation marks required, 4

## M

  materialized view logs, 1.3.9
    creating and editing, 4.28
  materialized views, 1.3.8
    options when creating or editing, 4.45
  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.12
  Microsoft Excel
    importing data, 4.23
  Microsoft SQL Server, 2.5.1
    connections, 4.12
    creating data files, 2.9.1.1
    third-party JDBC drivers, 1.13.5
  migration
    architecture, 2.2.1
    before you start (general), 2.4
    before you start (source-specific), 2.5
    deployment after migrating, 2.12
    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
  Monitor Sessions command, 1.2.1
  Monitor SQL command, 1.2.1
  moving a table to another tablespace, 1.3.18
  MySQL
    configuring before migrating, 2.5.3
    creating data files, 2.9.1.3
    third-party JDBC drivers, 1.13.5
  MySQL connections, 4.12
    zero date handling, 4.12

## N

  normalizing
    column data, 1.3.18

## O

  object search
    extended search, 1.10
    Find DB Object pane, 1.9
  objects
    database, 1.3
    exporting, 4.59
  OCI driver
    database advanced parameters preference, 1.13.5
  offline data transfer, 2.9.1
  offline generation of Oracle DDL, 4.76
  online help
    using, 1.16
  open SQL Worksheet automatically
    preference for database connections, 1.13.5
  operating system authentication, 4.12
  Oracle Application Express
    applications, 1.3.1
  Oracle Database connections, 4.12
  Oracle Web Agent (OWA), 1.7.6
  ORDER BY clause, 4.45
  OS authentication, 4.12
  OTN page
    SQL Developer, 1.17
  overview
    SQL Developer, 1
  OWA_OUTPUT pane, 1.7.6

## P

  packages
    creating, 4.29
    debugging, 4.105
    running, 4.105
  parallel data move streams, 1.13.10
  parameter insight, 1.13.3
  parse exception errors, 2.7.1
  partitioned tables
    partition definitions, 4.38
    partitioning options, 4.38
    subpartitioning options (templates), 4.38
  pathname
    for java.exe, 1.1
  pinning an object’s display, 1.2, 1.5, 1.12
  PL/SQL hierarchical profiler, 1.6.4
  PL/SQL packages
    creating, 4.29
  PL/SQL subprograms
    creating, 4.30
    debugging, 4.105
      breakpoints, 4.106
    running, 4.105
  plsql-dbms_output
    user-defined report example, 1.12.15.2
  preferences
    customizing SQL Developer, 1.13
  primary key, 4.38
  private database links, 1.3.3
  private synonyms, 1.3.17, 4.36
  privileges
    required for migration, 2.4.2
  procedures
    compiling, 1.3.11
    compiling for debug, 1.3.11
    creating, 4.30
  profiler (PL/SQL hierarchical), 1.6.4
  profiling a PL/SQL function or procedure, 4.105
  projects
    creating plan, 2.3.3
  proxy authentication, 1.4.5
  proxy connections, 1.4.5, 4.12
  public database links, 1.3.3
  public synonyms, 1.3.17, 4.36
  Publish to Apex (Application Express) option, 1.5

## Q

  query builder, 4.94
  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.6
  recompiling
    view, 1.3.22
  Recycle bin, 1.3.14
  remote debugging, 1.6.2
  replication schemes, 1.3.15
  report navigator, 1.12
  reports, 1.12
    bind variables for, 1.12
    exporting, 1.12
    importing, 1.12
    shared, 1.12
    user-defined
      chart example, 1.12.15.1
      creating and editing, 4.43
      dynamic HTML example, 1.12.15.2
      explanation, 1.12.15
      folders for, 1.12.15, 4.44
      gauge example, 1.7.8
      UserReports.xml, 1.12.15
  roles
    required for migration, 2.4.2
  running PL/SQL function or procedure, 1.6
    dialog box, 4.105

## S

  schema
    XML, 1.3.23, 4.46
  schema differences
    differences between two database schemas, 4.51
  schema documentation
    generating, 1.4
  schema objects, 1.3
  schema statistics
    gathering, 1.4
  scratch editor, 2.14.5
  script runner, 1.7.2
  scripts
    running, 1.7.2
  search
    extended, 1.10
  security
    Advanced Security for JDBC connection, 1.4.3
  SELECT clause, 4.45
  sequences, 1.3.16
    creating and editing, 4.32
    for populating table columns, 4.38
  sessions
    monitoring, 1.2.1
  shared reports, 1.12
  shortcut keys
    accelerator key mappings, 1.13.2
    for menus, 1.2
  shrinking a table, 1.3.18
  single record view, 4.119
  size of help text
    increasing or decreasing, 1.16
  snippets, 1.8
    user-defined, 1.8.1
  source database
    capturing, 2.6
  source schema
    database schema differences, 4.51
  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
    monitoring execution, 1.2.1
  SQL Developer preferences, 1.13
  SQL file
    creating, 4.33
  SQL scripts
    running, 1.7.2
  SQL Server
    configuring, 2.5.1
    creating data files, 2.9.1.1
    third-party JDBC drivers, 1.13.5
  SQL Server connections, 4.12
  SQL Trace files (.trc), 1.6.3
  SQL Worksheet
    closing automatically on disconnect, 1.13.5
    opening automatically on database connection, 1.13.5
    unshared for a connection, 1.4, 1.7
    using, 1.7
  SQLDEVELOPER_USER_DIR location, 1.14
  statistics
    computing table and column, 1.3.18
    estimating table and column, 1.3.18
    gathering schema, 1.4
  storage options, 4.39
  stored procedures
    generating for Migrate Blobs Offline, 1.13.10
  subpartitions
    templates, 4.38
  subprograms
    creating, 4.30
    debugging, 4.105
    running, 4.105
  substitution variables, 1.7.2
  Subversion
    preferences for, 1.13.11
    SQL Developer support for, 1.11
  Sybase Adaptive Server, 2.5.1
    connections, 4.12
    creating data files, 2.9.1.1
    third-party JDBC drivers, 1.13.5
  synonyms, 1.3.17
    creating and editing, 4.36

## T

  tables, 1.3.18
    analyzing, 1.3.18
    compacting, 1.3.18
    computing statistics, 1.3.18
    creating and editing, 4.38
    creating quickly, 4.37
    decrypting column data, 1.3.18
    encrypting column data, 1.3.18
    entering and modifying data, 1.5
    estimating statistics, 1.3.18
    exporting data, 1.3.18, 4.61, 4.62
    external
      properties, 4.38
    index-organized
      properties, 4.38
    locking, 1.3.18
    moving to another tablespace, 1.3.18
    normalizing column data, 1.3.18
    partitioned
      partition definitions, 4.38
      partitioning options, 4.38
      subpartitioning options (templates), 4.38
    shrinking, 1.3.18
    splitting the data pane, 1.5
    temporary, 4.38
    truncating, 1.3.18
    validating structure, 1.3.18
  temporary tables, 4.38
  thick (OCI) driver
    database advanced parameters preference, 1.13.5
  third-party databases
    configuring before migrating, 2.5
  third-party JDBC drivers, 1.13.5
  TimesTen
    cache groups, 1.3.2
    database connections, 4.12
    replication schemes, 1.3.15
    support for in SQL Developer, 1.15
  TKPROF
    opening in SQL Developer as an alternative to using, 1.6.3
  tnsnames.ora file, 1.4
  tools
    external, 1.2.1, 4.64, 4.65
  trace files (.trc), 1.6.3
  transferring
    data offline, 2.9.1
  translation scratch editor, 2.14.5
  .trc files, 1.6.3
  triggers, 1.3.19
    creating and editing, 4.40
  truncating a table, 1.3.18
  T-SQL
    not supported in worksheet for SQL Server or Sybase connection, 2.14.5
    translation to PL/SQL, 2.14.5
  tutorial
    creating objects for a small database, 3
  types
    creating, 4.41

## U

  unique constraints, 4.38
  unshared worksheet for a connection, 1.4, 1.7
  unusable indexes, 1.3.6
  updates
    checking for SQL Developer updates, 4.3
  user information directory (SQLDEVELOPER_USER_DIR), 1.14
  user interface
    restoring to original settings, 1.2.2
  user interface (UI), 1.2, 2.14
  user-defined extensions, 1.13.5
  user-defined reports
    chart example, 1.12.15.1
    creating and editing, 4.43
    dynamic HTML example, 1.12.15.2
    explanation, 1.12.15
    folders for, 1.12.15, 4.44
    gauge example, 1.7.8
    UserReports.xml, 1.12.15
  user-defined snippets, 1.8.1
  user-defined types
    creating, 4.41
  UserReports.xml, 1.12.15
  users
    creating and editing, 4.42

## V

  versioning
    preferences for, 1.13.11
    SQL Developer support for, 1.11
  viewlets
    SQL Developer, 1.17
  views, 1.3.22
    compiling, 1.3.22
    creating and editing, 4.45
    FROM clause, 4.45
    GROUP BY clause, 4.45
    HAVING clause, 4.45
    options when creating or editing, 4.45
    ORDER BY clause, 4.45
    recompiling, 1.3.22
    SELECT clause, 4.45
    splitting the data pane, 1.5
    WHERE clause, 4.45

## W

  watches, 1.6.5
  WHERE clause, 4.45

## X

  XML schema, 1.3.23
    creating, 4.46

## Z

  zero date handling
    MySQL connections, 4.12