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  

Symbols

A

  • abstract syntax tree (AST) 1.20.10
  • accelerator (shortcut) keys 1.20.12, 1.20.13
    • for menus 1.3
  • Active Session History (ASH) reports 1.19.5
  • advanced formatting options 1.20.3
  • Advanced Security for JDBC connection 1.5.3
  • analyzing tables 1.4.30
  • application
    • deploying (Application Express) 6.95
    • importing (Application Express) 6.95
  • Application Express
    • applications 1.4.1
    • deploying an application 6.95
    • importing an application 6.95
    • Publish to Apex option 1.6
    • refactor in bulk command 1.4.1
    • starting and stopping EPG (embedded PL/SQL gateway) 1.4.1
  • applications
    • Application Express 1.4.1
  • Apply Filter
  • ASH (Active Session History) reports 1.19.5
  • associations
  • AST (abstract syntax tree) 1.20.10
  • authentication
  • autocommit
    • preference for database connections 1.20.5
  • autocomplete preferences 1.20.3
  • auto-detect formatter settings 1.20.3
  • auto-enabling RESTful services 6.203
  • autogenerated connections 1.5
  • Auto-Generated connections folder 1.5
  • Automated Workload Repository (AWR) reports 1.19.5
  • autotrace
  • AWR (Automated Workload Repository) reports 1.19.5

B

  • bequeath connection type 6.33.1
  • Berkeley DB
    • data storage for Subversion repository 6.243
  • bind variables
  • blogs
    • SQL Developer 1.28
  • border color associated with connection 6.33
  • breakpoints
    • creating and editing 6.214

C

  • cache groups 1.4.2
  • cart
    • command-line interface 1.23
  • Cart (SQL Developer) 1.15
  • case insensitivity for queries
  • CDB
  • chains (Scheduler) 1.4.3
    • creating and editing 6.31
  • Change case as you type
    • completion insight option 1.20.3
  • charts
  • check constraints 6.73.6
  • Check for Updates feature 6.8
  • CLOBtoBLOB_sqldeveloper stored procedure 1.20.10
  • close all SQL Worksheets automatically on disconnect
    • preference for database connections 1.20.5
  • clustered primary keys (Sybase)
    • generating as Oracle index-organized tables 1.20.10
  • clustered unique indexes (Sybase)
    • generating as Oracle index-organized tables 1.20.10
  • coalescing an index 1.4.12
  • code coverage
    • gathering and viewing statistics 4.4
  • code fragments 1.9
  • code insight (completion insight) 1.20.3
  • columns
  • column sequences 6.73.10
  • command-line interface 1.23
  • command line interface to SQL Developer 1.23
  • Compact option for shrinking a table 1.4.30
  • compiling
  • completion
    • SQL Developer preferences 1.20.3
  • completion insight 1.20.3
  • compound triggers 1.20.10
  • configuring 2.2.4.2
    • third-party databases 2.2.4
  • configuring file type associations 6.16
  • connection color 6.33
  • connections
  • constraints
  • converted model
    • correcting errors in 2.2.6.1
    • creating and customizing 2.2.6
  • Create Local Connections command 1.5
  • Create Unit Test wizard 6.276
  • create users option (migration generation options) 1.20.10
  • credentials (Scheduler) 1.4.4
    • creating and editing 6.32
  • crossedition triggers 1.4.31
  • customizing SQL Developer
    • setting preferences 1.20
  • CVS (Concurrent Versions System)

D

  • data
    • entering and modifying 1.6
  • database administrator (DBA) features in SQL Developer 1.13
  • database connections 6.33.9
  • database destination groups (Scheduler) 1.4.7
    • creating and editing 6.55
  • database destinations (Scheduler) 1.4.5
    • creating and editing 6.54
  • database instance viewer
  • database links 1.4.6
    • creating or editing 6.56
  • database objects 1.4
  • database schema differences
    • differences between two database schemas 6.91, 6.98
  • Data Modeler
    • included in SQL Developer 1.24
  • data move
  • Data Pump Export wizard 6.88
  • Data Pump Import wizard 6.89
  • data redaction 1.4.30
  • data types
  • DB2
  • DB2 (IBM) connections 6.33.4
  • DBA features in SQL Developer
  • DBMS_OUTPUT
  • DBMS_OUTPUT pane 1.8.5
  • debugging PL/SQL function or procedure 1.7
  • decryption
    • data in a table column 1.4.30
  • default password
    • Use Default Password connection option 6.33.9
  • deploying objects using the Cart 1.15
  • deployment
    • after database migration 2.2.11
  • destination groups (Scheduler) 1.4.7
    • creating and editing 6.55
  • destinations
    • database (Scheduler) 1.4.5
  • destination schema
    • database schema differences 6.91, 6.98
  • dialog boxes and tabs 6
  • diff
    • command-line interface 1.23
  • directories (directory objects) 1.4.8
  • disabled constraints 1.19.13
  • discussion forum
    • SQL Developer 1.28
  • documentation
    • generating for schema 1.5
  • downloads
    • SQL Developer 1.28
  • drag and drop effects 1.20.5
  • drivers
  • dynamic HTML

E

  • editions 1.4.9
    • crossedition triggers 1.4.31
  • embedded PL/SQL gateway (EPG) for Application Express
    • starting and stopping 1.4.1
  • emulation user
  • Enable Semantic Analysis Info Tip 1.20.3
  • encryption
    • data in a table column 1.4.30
  • entering data in tables 1.6
  • EPG (embedded PL/SQL gateway) for Application Express
    • starting and stopping 1.4.1
  • errors
  • Excel
    • importing data 6.52
  • execution plan 1.8.3
  • expired password
    • resetting 1.5
  • EXPLAIN PLAN
  • export
    • command-line interface 1.23
  • exporting
  • expression watches 1.7.5
  • extensions 6.112
  • external destination groups (Scheduler) 1.4.7
  • external editor
    • SQL Developer preferences 1.20.7
  • external tables
  • external tools 1.3.1, 6.111, 6.112

F

  • F10 key
    • for File menu 1.3
  • F4 key 1.8
    • Alt+F4 to close window with focus 1.3
  • failed objects
  • features
  • file-oriented development
    • SQL Worksheet right-click operations 1.8
  • Files navigator 1.3
  • file types
    • associating with SQL Developer 6.16
  • file watchers (Scheduler) 1.4.10
    • creating and editing 6.58
  • filter
  • finding database objects 1.10
  • Flashback Table support 1.4.30.1
  • folders
  • font
    • increasing or decreasing size for help text 1.26
  • foreign keys 6.73.5
  • formatter
  • Freeze View
  • FROM clause 6.81.5
  • full pathname for java.exe 1.2
  • functions

G

  • Gather Code Coverage Statistics option 4.4
  • Gather Schema Statistics menu command 1.5
  • gauges
    • in SQL Worksheet and user-defined reports 1.8.11
  • Generate DB Doc menu command 1.5
  • generate failed objects option 1.20.10
  • generate separate emulation user option 1.20.10
  • Git
  • grant information
    • not migrated to Oracle 2.2.3
  • graphical user interface (GUI) 1.3, 2.3
    • unit testing 4.2
  • GROUP BY clause 6.81.8
  • groups
    • connections in folders 1.5.1

H

  • HAVING clause 6.81.9
  • help
    • increasing or decreasing help text font size 1.26
    • using the online help 1.26
  • hierarchical profiler (PL/SQL) 1.7.4
  • Hive connections 6.33.5
  • HTML

I

J

  • java.exe
    • pathname for 1.2
  • Java sources 1.4.13
  • JDBC connections 6.33.6
  • JDBC drivers 1.20.5
  • JDK location
    • specified in product.conf 1.22
  • job classes (Scheduler) 1.4.15
    • creating and editing 6.62
  • jobs
    • scheduling using SQL Developer 1.14
  • jobs (Scheduler) 1.4.14
    • creating and editing 6.61
  • job scheduler
    • using in SQL Developer 1.14
  • jTDS
    • JDBC driver for Microsoft SQL Server and Sybase Adaptive Server 1.20.5

K

L

  • least privilege schema migration 1.20.10
  • library
    • adding an item for unit testing 6.271
    • unit testing 4.8
  • link
  • Load Extension 6.157
  • LOB parameters 6.73.12
  • local connections
  • locking a table 1.4.30
  • lookups
  • lowercase characters in object names
    • quotation marks required 6

M

  • materialized view logs 1.4.18
    • creating and editing 6.63
  • materialized views 1.4.17
    • options when creating or editing 6.81.2
  • Microsoft Excel
    • importing data 6.52
  • Microsoft SQL Server 2.2.4.2
  • migration
    • before you start (general) 2.2.3
    • before you start (source-specific) 2.2.4
    • command-line interface 1.23
    • deployment after migrating 2.2.11
    • introduction and main topics 2
    • overview 2.2.1
    • planning for 2.2.2
    • quick start 2.1
    • required roles and privileges 2.2.3.2
  • migration plan
  • migration repository
    • creating database user for 2.2.3.1
  • MIME type
    • specifying external editor for BLOB data 1.20.7
  • MOD_PLSQL
  • modifying data in tables 1.6
  • Monitor Sessions command 1.3.1
  • Monitor SQL command 1.3.1
  • moving a table to another tablespace 1.4.30
  • multitenant container database (CDB)
  • MySQL
  • MySQL connections 6.33.7

N

  • navigation tree filtering option 1.20.5
  • New Worksheet to use unshared connection
    • preference for database SQL Worksheet
      • using unshared connection automatically 1.20.5
  • normalizing

O

  • OBEs (Oracle By Example lessons) 1.28
  • objects
  • OCI driver
    • database advanced parameters preference 1.20.5
  • offline data transfer 2.2.8.1
  • OLAP DML statements
    • entering in SQL Worksheet 1.8.12
  • online help
  • Open command on Connections navigator context menu 1.4
  • open SQL Worksheet automatically
    • preference for database connections 1.20.5
  • operating system authentication 6.33.1
  • ORA_ROWSCN pseudocolumn
    • "Use ORA_ROWSCN for DataEditor insert and update statements" preference 1.20.5
  • Oracle Application Express
  • Oracle By Example (OBE) lessons 1.28
  • Oracle Database 12c features
  • Oracle Database connections 6.33.1
  • Oracle Web Agent (OWA) 1.8.6
  • ORDER BY clause 6.81.10
  • OS authentication 6.33.1
  • OTN page
    • SQL Developer 1.28
  • overview
    • SQL Developer 1
  • overview display of database objects
    • Open command on context menu 1.4
  • OWA_OUTPUT pane 1.8.6

P

  • packages
  • parallel data move streams 1.20.10
  • parameter insight 1.20.3
  • parse exception errors 2.2.6.1
  • partitioned tables
  • password
    • resetting expired 1.5
  • pathname
    • for java.exe 1.2
  • PDB
  • Perforce
  • pinning an object’s display 1.3, 1.6, 1.19
  • PL/SQL hierarchical profiler 1.7.4
  • PL/SQL packages
  • PL/SQL subprograms
  • plsql-dbms_output
  • pluggable database (PDB)
  • pluggable databases
  • PostgreSQL
  • preferences
    • customizing SQL Developer 1.20
  • preferences (options) 1.20.14
  • primary key 6.73.3
  • private database links 1.4.6
  • private synonyms 1.4.29, 6.71
  • privileges
  • procedures
  • product.conf file 1.22
  • profiler (PL/SQL hierarchical) 1.7.4
  • profiling a PL/SQL function or procedure 6.213
  • programs (Scheduler) 1.4.22
    • creating and editing 6.66
  • projects
  • proxy authentication 1.5.5
  • proxy connections 1.5.5, 6.33.1
  • public database links 1.4.6
  • public synonyms 1.4.29, 6.71
  • Publish to Apex (Application Express) option 1.6

Q

  • query builder 1.8.8
  • quotation marks
    • for name with lowercase characters, special characters, or spaces 6

R

S

  • scheduler
    • using in SQL Developer 1.14
  • schedules (Scheduler) 1.4.27
    • creating and editing 6.68
  • scheduling jobs in SQL Developer 1.14
  • schema
  • Schema Browser 1.5
  • schema differences
    • differences between two database schemas 6.91, 6.98
  • schema documentation
    • generating 1.5
  • schema objects 1.4
  • schema statistics
    • gathering 1.5
  • scratch editor 2.3.5
  • script runner 1.8.2
  • scripts
  • search
    • for database objects 1.10
  • Secure Shell (SSH)
  • security
    • Advanced Security for JDBC connection 1.5.3
  • SELECT clause 6.81.6
  • Semantic Analysis Info Tip
  • sequences 1.4.28
    • creating and editing 6.69
    • for populating table columns 6.73.10
  • SerDe class (Hive tables) 6.73.21.1
  • sessions
  • SetJavaHome line in product.conf file 1.22
  • shared reports 1.19
  • shared repository 4.3
  • shortcut keys 1.20.12, 1.20.13
    • for menus 1.3
    • restoring to default scheme 1.20.12
  • shrinking a table 1.4.30
  • single record view 6.229
  • size of help text
    • increasing or decreasing 1.26
  • snippets 1.9
  • source database
  • source schema
    • database schema differences 6.91, 6.98
  • spaces in object names
    • quotation marks required 6
  • Spatial support
    • Maintain Spatial Metadata dialog box 6.160
    • Validate Geometry dialog box 6.283
  • special characters in object names
    • quotation marks required 6
  • split
    • data pane for a table or view 1.6
  • SQL
    • monitoring execution 1.3.1
  • SQL Developer preferences 1.20
  • SQL file
  • SQL formatting
  • SQL scripts
  • SQL Server
  • SQL Server connections 6.33.9
  • SQL Trace files (.trc) 1.7.3
  • SQL Worksheet
    • closing automatically on disconnect 1.20.5
    • entering OLAP DML statements 1.8.12
    • opening automatically on database connection 1.20.5
    • unshared for a connection 1.5, 1.8
    • using 1.8
  • SSH
  • Start Page for SQL Developer 1.28
  • statistics
    • computing table and column 1.4.30
    • estimating table and column 1.4.30
    • gathering schema 1.5
  • storage options 6.74
  • stored procedures
    • generating for Migrate Blobs Offline 1.20.10
  • subpartitions
  • subprograms
  • substitution variables 1.8.2
  • Subversion
  • SVN
  • Sybase Adaptive Server 2.2.4.2
  • Sybase clustered primary keys
    • generating as Oracle index-organized tables 1.20.10
  • Sybase clustered unique indexes
    • generating as Oracle index-organized tables 1.20.10
  • Synchronize Unit Test wizard 6.280
  • synonyms 1.4.29
    • creating and editing 6.71

T

  • tables 1.4.30
  • tablespaces
    • creating and editing 6.75
  • Target Oracle Database 12c features in migration option 1.20.10
  • temporary tables 6.73
  • Teradata
  • test case
    • definition of 4.1
  • test suite
    • definition of 4.1
  • thick (OCI) driver
    • database advanced parameters preference 1.20.5
  • third-party databases
    • configuring before migrating 2.2.4
  • third-party JDBC drivers 1.20.5
  • TimesTen
    • cache groups 1.4.2
    • database connections 6.33.2
    • replication schemes 1.4.26
    • support for in SQL Developer 1.25
  • Tip of the Day 1.27
  • TKPROF
    • opening in SQL Developer as an alternative to using 1.7.3
  • tnsnames.ora file 1.5
  • tools
  • trace files (.trc) 1.7.3
  • transferring
  • translation scratch editor 2.3.5
  • triggers 1.4.31
  • truncating a table 1.4.30
  • T-SQL
    • not supported in worksheet for SQL Server or Sybase connection 2.3.5
    • translation to PL/SQL 2.3.5
  • tutorial
    • creating objects for a small database 5
  • types

U

  • unique constraints 6.73.4
  • unit test
    • definition of (as related to test cases) 4.1
  • unit testing 1.20.14
    • adding a category for lookups 6.269, 6.270
    • adding an implementation 6.272, 6.273, 6.274
    • adding an item to a library 6.271
    • best practices 4.12
    • command-line interface 1.23, 4.11
    • copying or renaming a unit test 6.275
    • Create Unit Test wizard 6.276
    • editing and running a unit test 4.4
    • example 4.13
    • exporting objects 4.10
    • graphical user interface (GUI) 4.2
    • importing objects 4.10
    • introduction and main topics 4
    • library 4.8
    • managing users 6.277
    • overview 4.1
    • renaming an implementation 6.278
    • reports 4.9
    • repository 4.3
    • Synchronize Unit Test wizard 6.280
    • tutorial 4.13
    • variable substitution 4.7
  • unloadiing
    • database objects 6.92
  • unshared connection
    • preference for using on new worksheet 1.20.5
  • unshared worksheet for a connection 1.5, 1.8
  • unusable indexes 1.4.12
  • updates
    • checking for SQL Developer updates 6.8
    • managing 6.163
  • URI pattern 3.4.2
  • URI template 3.4.2
  • usage suggestions 1.27
  • Use as Template command on context menu 1.4
  • Use Default Password connection option 6.33.9
  • user-defined extensions 1.20.5
  • user-defined reports
  • user-defined snippets 1.9.1
  • user-defined types
  • user information directory (IDE_USER_DIR) 1.21
  • user interface
    • restoring to original settings 1.3.2
  • user interface (UI) 1.3, 2.3
    • unit testing 4.2
  • UserReports.xml 1.19.16
  • users
    • creating and editing 6.78
  • Use Windows Authentication connection option 6.33.9
  • using 1.13
  • UT_REPO_ADMINISTRATOR role 4.3.1
  • UT_REPO_USER role 4.3.1

V

W

  • watches 1.7.5
  • WHERE clause 6.81.7
  • window groups (Scheduler) 1.4.35
    • creating and editing 6.83
  • windows (Scheduler) 1.4.36
    • creating and editing 6.82
  • Windows authentication
    • Use Windows Authentication connection option 6.33.9

X

Z

  • zero date handling