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

  • .trc files 1

A

  • abstract syntax tree (AST) 1
  • accelerator (shortcut) keys 1 , 2
    • for menus 1
  • Active Session History (ASH) reports 1
  • advanced formatting options 1
  • Advanced Security for JDBC connection 1
  • aging policy
    • defined 1
    • LRU 1
    • time-based 1
  • analyzing tables 1
  • application
    • deploying (Application Express) 1
    • importing (Application Express) 1
  • Application Express
    • applications 1
    • deploying an application 1
    • importing an application 1
    • Publish to Apex option 1
    • refactor in bulk command 1
    • starting and stopping EPG (embedded PL/SQL gateway) 1
  • applications
    • Application Express 1
  • Apply Filter
    • to display of objects 1 , 2
  • ASH (Active Session History) reports 1
  • associations
    • file types 1
  • AST (abstract syntax tree) 1
  • authentication
    • Kerberos 1
      • Database Advanced Parameters 1
    • OS (operating system) 1
  • autocommit
    • preference for database connections 1
  • autocomplete preferences 1
  • auto-detect formatter settings 1
  • auto-enabling RESTful services 1
  • autogenerated connections 1
  • Auto-Generated connections folder 1
  • Automated Workload Repository (AWR) reports 1
  • autotrace
    • Autotrace pane 1
    • preferences for 1
  • AWR (Automated Workload Repository) reports 1

B

  • bequeath connection type 1
  • Berkeley DB
    • data storage for Subversion repository 1
  • bind variables
    • for reports 1
    • saving to disk on exit 1
  • blogs
    • SQL Developer 1
  • border color associated with connection 1
  • breakpoints
    • creating and editing 1

C

  • cache agent
    • start and stop dialog 1
  • cache group
    • create dialog 1
    • user managed 1
  • cache groups 1
    • asynchronous writethrough 1
    • dynamic 1
    • explicitly loaded 1
    • global 1
    • local 1
    • read-only 1
    • root table 1
    • selecting the columns to cache 1
    • synchronous writethrough 1
  • cache table
    • aging 1
  • cart
    • command-line interface 1
  • Cart (SQL Developer) 1
  • case insensitivity for queries
    • setting 1
  • CDB
    • definition 1
  • chains (Scheduler) 1
    • creating and editing 1
  • Change case as you type
    • completion insight option 1
  • charts
    • user-defined report example 1
  • check constraints 1
  • Check for Updates feature 1
  • child table
    • defining foreign keys 1
    • selecting columns to cache 1
    • specifying the table attributes 1
  • child tables
    • defining 1
  • CLOBtoBLOB_sqldeveloper stored procedure 1
  • close all SQL Worksheets automatically on disconnect
    • preference for database connections 1
  • clustered primary keys (Sybase)
    • generating as Oracle index-organized tables 1
  • clustered unique indexes (Sybase)
    • generating as Oracle index-organized tables 1
  • coalescing an index 1
  • code coverage
    • gathering and viewing statistics 1
  • code fragments 1
  • code insight (completion insight) 1
  • columns
    • decrypting 1
    • encrypting 1
    • normalizing column data 1
  • column sequences 1
  • command-line interface 1
  • command line interface to SQL Developer 1
  • Compact option for shrinking a table 1
  • compiling
    • function 1 , 2
      • for debug 1 , 2
    • view 1
  • completion
    • SQL Developer preferences 1
  • completion insight 1
  • compound triggers 1
  • configuring 1
    • third-party databases 1
  • configuring file type associations 1
  • connection
    • new 1
  • connection color 1
  • connections
    • creating, editing, or selecting 1
    • explanation 1
    • Hive 1
    • IBM DB2 1
    • JDBC 1
    • Microsoft SQL Server 1
    • MySQL 1
    • Oracle Database 1
    • Oracle TimesTen 1
    • PostgreSQL 1
    • separate unshared connection preference 1
    • separate unshared worksheet for 1 , 2
    • Sybase Adaptive Server 1
    • Teradata 1
    • using folders to group 1
  • constraint
    • dropping 1
  • constraints
    • check 1
    • disabled 1
    • unique 1
  • converted model
    • correcting errors in 1
    • creating and customizing 1
  • Create Local Connections command 1
  • Create Unit Test wizard 1
  • create users option (migration generation options) 1
  • credentials (Scheduler) 1
    • creating and editing 1
  • crossedition triggers 1
  • customizing SQL Developer
    • setting preferences 1
  • CVS (Concurrent Versions System)
    • preferences for 1
    • SQL Developer support for 1

D

  • data
    • entering and modifying 1
  • database administrator (DBA) features in SQL Developer 1
  • database connections 1
    • creating, editing, or selecting 1
    • explanation 1
    • Hive 1
    • IBM DB2 1
    • JDBC 1
    • Microsoft SQL Server 1
    • MySQL 1
    • Oracle Database 1
    • Oracle TimesTen 1
    • PostgreSQL 1
    • Sybase Adaptive Server 1
    • Teradata 1
  • database destination groups (Scheduler) 1
    • creating and editing 1
  • database destinations (Scheduler) 1
    • creating and editing 1
  • database instance viewer
    • preferences 1
  • database links 1
    • creating or editing 1
  • database objects 1
    • exporting 1
    • finding (searching for) 1
    • recent 1
    • unloadiing 1
  • database schema differences
    • differences between two database schemas 1 , 2
  • Data Modeler
    • included in SQL Developer 1
  • data move
    • number of parallel streams 1
    • options 1
  • Data Pump Export wizard 1
  • Data Pump Import wizard 1
  • data redaction 1
  • data types
    • creating 1
  • DB2
    • before migrating 1
  • DB2 (IBM) connections 1
  • DBA features in SQL Developer
    • using 1
  • DBMS_OUTPUT
    • user-defined report example 1
  • DBMS_OUTPUT pane 1
  • debugging PL/SQL function or procedure 1
    • dialog box 1
    • remote debugging 1
  • decryption
    • data in a table column 1
  • default password
    • Use Default Password connection option 1
  • deploying objects using the Cart 1
  • deployment
    • after database migration 1
  • destination groups (Scheduler) 1
    • creating and editing 1
  • destinations
    • database (Scheduler) 1
  • destination schema
    • database schema differences 1 , 2
  • dialog boxes and tabs 1
  • diff
    • command-line interface 1
  • directories (directory objects) 1
  • disabled constraints 1
  • discussion forum
    • SQL Developer 1
  • documentation
    • generating for schema 1
  • downloads
    • SQL Developer 1
  • drag and drop effects 1
  • drivers
    • third-party JDBC 1
  • dynamic HTML
    • user-defined report example 1

E

  • editions 1
    • crossedition triggers 1
  • embedded PL/SQL gateway (EPG) for Application Express
    • starting and stopping 1
  • emulation user
    • generating separate 1
  • Enable Semantic Analysis Info Tip 1
  • encryption
    • data in a table column 1
  • entering data in tables 1
  • EPG (embedded PL/SQL gateway) for Application Express
    • starting and stopping 1
  • errors
    • parse exceptions 1
  • Excel
    • importing data 1
  • execution plan 1
  • expired password
    • resetting 1
  • EXPLAIN PLAN
    • execution plan 1
  • export
    • command-line interface 1
  • exporting
    • database objects 1
    • reports 1
    • table data 1 , 2
    • unit test objects 1
  • expression watches 1
  • extensions 1
    • loading 1
    • SQL Developer 1
    • user-defined 1
  • external destination groups (Scheduler) 1
  • external editor
    • SQL Developer preferences 1
  • external tables
    • properties 1
  • external tools 1 , 2 , 3

F

  • F10 key
    • for File menu 1
  • F4 key 1
    • Alt+F4 to close window with focus 1
  • failed objects
    • generating 1
  • features
    • managing 1
  • file-oriented development
    • SQL Worksheet right-click operations 1
  • Files navigator 1
  • file types
    • associating with SQL Developer 1
  • file watchers (Scheduler) 1
    • creating and editing 1
  • filter
    • applying 1 , 2
    • clearing 1 , 2
  • finding database objects 1
  • Flashback Table support 1
  • folders
    • for user-defined reports 1 , 2
    • in Connections navigator 1
  • font
    • increasing or decreasing size for help text 1
  • foreign key constraint
    • creating 1
  • foreign keys 1
  • formatter
    • command-line interface 1 , 2
  • Freeze View
    • pinning an object’s display 1 , 2 , 3
  • FROM clause 1
  • full pathname for java.exe 1
  • functions
    • compiling 1 , 2
    • compiling for debug 1 , 2
    • creating 1
    • debugging 1
    • running 1

G

  • Gather Code Coverage Statistics option 1
  • Gather Schema Statistics menu command 1
  • gauges
    • in SQL Worksheet and user-defined reports 1
  • Generate DB Doc menu command 1
  • generate failed objects option 1
  • generate separate emulation user option 1
  • Git
    • preferences for 1
  • grant information
    • not migrated to Oracle 1
  • graphical user interface (GUI) 1 , 2
    • unit testing 1
  • GROUP BY clause 1
  • groups
    • connections in folders 1

H

  • HAVING clause 1
  • help
    • increasing or decreasing help text font size 1
    • using the online help 1
  • hierarchical profiler (PL/SQL) 1
  • Hive connections 1
  • HTML
    • dynamic (user-defined report) 1

I

  • IBM DB2
    • before migrating 1
  • IBM DB2 connections 1
  • IDE_USER_DIR location 1
  • IM column store 1
  • implementation
    • adding for a unit test 1 , 2 , 3
    • renaming for a unit test 1
  • import
    • command-line interface 1
  • importing
    • Microsoft Excel data 1
    • reports 1
    • unit test objects 1
  • indexes 1
    • coalescing 1
    • creating or editing 1
    • explanation 1
    • making unusable 1
    • rebuilding 1
  • index-organized tables
    • properties 1
  • In-Memory Column Store 1
  • instance viewer
    • preferences 1
  • introduction
    • SQL Developer 1

J

  • java.exe
    • pathname for 1
  • Java sources 1
  • JDBC connections 1
  • JDBC drivers 1
  • JDK location
    • specified in product.conf 1
  • job classes (Scheduler) 1
    • creating and editing 1
  • jobs
    • scheduling using SQL Developer 1
  • jobs (Scheduler) 1
    • creating and editing 1
  • job scheduler
    • using in SQL Developer 1
  • jTDS
    • JDBC driver for Microsoft SQL Server and Sybase Adaptive Server 1

K

  • Kerberos authentication 1
    • Database Advanced Parameters 1
  • keyboard shortcuts 1 , 2

L

  • least privilege schema migration 1
  • library
    • adding an item for unit testing 1
    • unit testing 1
  • link
    • database 1
  • Load Extension 1
  • LOB parameters 1
  • local connections
    • creating 1
  • locking a table 1
  • lookups
    • adding for unit testing 1 , 2
  • lowercase characters in object names
    • quotation marks required 1

M

  • materialized view logs 1
    • creating and editing 1
  • materialized views 1
    • options when creating or editing 1
  • Microsoft Excel
    • importing data 1
  • Microsoft SQL Server 1
    • connections 1
    • creating data files 1
    • third-party JDBC drivers 1
  • migration
    • before you start (general) 1
    • before you start (source-specific) 1
    • command-line interface 1
    • deployment after migrating 1
    • introduction and main topics 1
    • overview 1
    • planning for 1
    • quick start 1
    • required roles and privileges 1
  • migration plan
    • preparing 1
  • migration repository
    • creating database user for 1
  • MIME type
    • specifying external editor for BLOB data 1
  • MOD_PLSQL
    • OWA output 1
  • modifying data in tables 1
  • Monitor Sessions command 1
  • Monitor SQL command 1
  • moving a table to another tablespace 1
  • multitenant container database (CDB)
    • definition 1
  • MySQL
    • configuring before migrating 1
    • creating data files 1
    • third-party JDBC drivers 1
  • MySQL connections 1
    • zero date handling 1

N

  • navigation tree filtering option 1
  • new connection dialog 1
  • New Worksheet to use unshared connection
    • preference for database SQL Worksheet
      • using unshared connection automatically 1
  • normalizing
    • column data 1

O

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

P

  • packages
    • creating 1
    • debugging 1
    • running 1
  • parallel data move streams 1
  • parameter insight 1
  • parse exception errors 1
  • partitioned tables
    • partition definitions 1
    • partitioning options 1
    • subpartitioning options (templates) 1
  • password
    • resetting expired 1
  • pathname
    • for java.exe 1
  • PDB
    • definition 1
  • Perforce
    • preferences for 1
  • pinning an object’s display 1 , 2 , 3
  • PL/SQL hierarchical profiler 1
  • PL/SQL packages
    • creating 1
  • PL/SQL subprograms
    • debugging 1
      • breakpoints 1
    • running 1
  • plsql-dbms_output
    • user-defined report example 1
  • pluggable database (PDB)
    • definition 1
  • pluggable databases
    • cloning 1
    • cloning to Oracle Cloud 1
    • creating 1 , 2
    • dropping 1
    • plugging in 1
    • unplugging 1
  • PostgreSQL
    • connections 1
    • third-party JDBC drivers 1
  • preferences
    • customizing SQL Developer 1
  • preferences (options) 1
  • primary key 1
  • primary key attributes
    • changing 1
  • primary key constraint
    • creating 1
  • private database links 1
  • private synonyms 1 , 2
  • privileges
    • required for migration 1
  • procedures
    • creating 1
  • product.conf file 1
  • profiler (PL/SQL hierarchical) 1
  • profiling a PL/SQL function or procedure 1
  • programs (Scheduler) 1
    • creating and editing 1
  • projects
    • creating plan 1
  • proxy authentication 1
  • proxy connections 1 , 2
  • public database links 1
  • public synonyms 1 , 2
  • Publish to Apex (Application Express) option 1

Q

  • query builder 1
  • query optimizer
    • statistics detail 1
  • quotation marks
    • for name with lowercase characters, special characters, or spaces 1

R

  • Raptor
    • former code name for SQL Developer 1
  • rebuilding an index 1
  • recent objects 1
  • recompiling
    • view 1
  • Recycle bin 1
  • redaction 1
  • refactor in bulk 1
  • remote debugging 1
  • replication schemes 1
  • report navigator 1
  • reports 1
    • bind variables for 1
    • exporting 1
    • importing 1
    • shared 1
    • unit testing 1
    • user-defined
      • chart example 1
      • creating and editing 1
      • dynamic HTML example 1
      • explanation 1
      • folders for 1 , 2
      • gauge example 1
      • UserReports.xml 1
  • repository
    • unit test 1
  • Reset Password menu command 1
  • resource handler 1
    • creating 1
  • resource module 1
  • resource template 1
    • creating 1
  • REST Data Services administration 1
  • RESTful service module
    • creating 1
  • RESTful services
    • auto-enabling for schema, table, or view 1
  • roles
    • creating and editing 1
    • required for migration 1
  • root table
    • primary key 1
    • where clause 1
  • root table definition
    • verifying 1
  • root table dialog 1
  • route pattern 1
  • running PL/SQL function or procedure 1
    • dialog box 1

S

  • scheduler
    • using in SQL Developer 1
  • schedules (Scheduler) 1
    • creating and editing 1
  • scheduling jobs in SQL Developer 1
  • schema
    • XML 1 , 2 , 3
  • Schema Browser 1
  • schema differences
    • differences between two database schemas 1 , 2
  • schema documentation
    • generating 1
  • schema objects 1
  • schema statistics
    • gathering 1
  • scratch editor 1
  • script runner 1
  • scripts
    • running 1
  • search
    • for database objects 1
  • Secure Shell (SSH)
    • authentication 1
    • connections 1
  • security
    • Advanced Security for JDBC connection 1
  • SELECT clause 1
  • Semantic Analysis Info Tip
    • enabling 1
  • sequences 1
    • creating and editing 1
    • for populating table columns 1
  • SerDe class (Hive tables) 1
  • sessions
    • monitoring 1
  • SetJavaHome line in product.conf file 1
  • shared reports 1
  • shared repository 1
  • shortcut keys 1 , 2
    • for menus 1
    • restoring to default scheme 1
  • shrinking a table 1
  • single record view 1
  • size of help text
    • increasing or decreasing 1
  • snippets 1
    • user-defined 1
  • source database
    • capturing 1
  • source schema
    • database schema differences 1 , 2
  • spaces in object names
    • quotation marks required 1
  • Spatial support
    • Maintain Spatial Metadata dialog box 1
    • Validate Geometry dialog box 1
  • special characters in object names
    • quotation marks required 1
  • split
    • data pane for a table or view 1
  • SQL
    • monitoring execution 1
  • SQL Developer preferences 1
  • SQL file
    • creating 1
  • SQL formatting
    • command-line interface 1 , 2
  • SQL scripts
    • running 1
  • SQL Server
    • configuring 1
    • creating data files 1
    • third-party JDBC drivers 1
  • SQL Server connections 1
  • SQL Trace files (.trc) 1
  • SQL Worksheet
    • closing automatically on disconnect 1
    • entering OLAP DML statements 1
    • opening automatically on database connection 1
    • unshared for a connection 1 , 2
    • using 1
  • SSH
    • authentication 1
    • connections 1
  • Start Page for SQL Developer 1
  • statistics
    • computing table and column 1
    • estimating table and column 1
    • gathering schema 1
  • storage options 1
  • stored procedures
    • generating for Migrate Blobs Offline 1
  • subpartitions
    • templates 1
  • subprograms
    • creating 1
    • debugging 1
    • running 1
  • substitution variables 1
  • Subversion
    • preferences for 1
    • SQL Developer support for 1
  • SVN
    • preferences for 1
  • Sybase Adaptive Server 1
    • connections 1
    • creating data files 1
    • third-party JDBC drivers 1
  • Sybase clustered primary keys
    • generating as Oracle index-organized tables 1
  • Sybase clustered unique indexes
    • generating as Oracle index-organized tables 1
  • Synchronize Unit Test wizard 1
  • synonyms 1
    • creating and editing 1

T

  • tables 1
    • analyzing 1
    • compacting 1
    • computing statistics 1
    • creating and editing 1
    • creating quickly 1
    • decrypting column data 1
    • encrypting column data 1
    • entering and modifying data 1
    • estimating statistics 1
    • exporting data 1 , 2
    • external
      • properties 1
    • index-organized
      • properties 1
    • in-memory 1
    • locking 1
    • moving to another tablespace 1
    • normalizing column data 1
    • partitioned
      • partition definitions 1
      • partitioning options 1
      • subpartitioning options (templates) 1
    • shrinking 1
    • splitting the data pane 1
    • temporary 1
    • truncating 1
    • validating structure 1
  • tablespaces
    • creating and editing 1
  • Target Oracle Database 12c features in migration option 1
  • temporary tables 1
  • Teradata
    • before migrating 1
    • connections 1
  • test case
    • definition of 1
  • test suite
    • definition of 1
  • thick (OCI) driver
    • database advanced parameters preference 1
  • third-party databases
    • configuring before migrating 1
  • third-party JDBC drivers 1
  • time-based aging 1
  • TimesTen
    • cache groups 1
    • database connections 1
    • replication schemes 1
    • support for in SQL Developer 1
    • tasks (how to perform in SQL Developer) 1
  • Tip of the Day 1
  • TKPROF
    • opening in SQL Developer as an alternative to using 1
  • tnsnames.ora file 1
  • tools
    • external 1 , 2 , 3
  • trace files (.trc) 1
  • transferring
    • data offline 1
  • translation scratch editor 1
  • triggers 1
    • compound 1
    • creating and editing 1
  • truncating a table 1
  • T-SQL
    • not supported in worksheet for SQL Server or Sybase connection 1
    • translation to PL/SQL 1
  • tutorial
    • creating objects for a small database 1
  • types
    • creating 1

U

  • unique constraints 1
  • unit test
    • definition of (as related to test cases) 1
  • unit testing 1
    • adding a category for lookups 1 , 2
    • adding an implementation 1 , 2 , 3
    • adding an item to a library 1
    • best practices 1
    • command-line interface 1 , 2
    • copying or renaming a unit test 1
    • Create Unit Test wizard 1
    • editing and running a unit test 1
    • example 1
    • exporting objects 1
    • graphical user interface (GUI) 1
    • importing objects 1
    • introduction and main topics 1
    • library 1
    • managing users 1
    • overview 1
    • renaming an implementation 1
    • reports 1
    • repository 1
    • Synchronize Unit Test wizard 1
    • tutorial 1
    • variable substitution 1
  • unloadiing
    • database objects 1
  • unshared connection
    • preference for using on new worksheet 1
  • unshared worksheet for a connection 1 , 2
  • unusable indexes 1
  • updates
    • checking for SQL Developer updates 1
    • managing 1
  • URI pattern 1
  • URI template 1
  • usage suggestions 1
  • Use as Template command on context menu 1
  • Use Default Password connection option 1
  • user-defined extensions 1
  • user-defined reports
    • chart example 1
    • creating and editing 1
    • dynamic HTML example 1
    • explanation 1
    • folders for 1 , 2
    • gauge example 1
    • UserReports.xml 1
  • user-defined snippets 1
  • user-defined types
    • creating 1
  • user information directory (IDE_USER_DIR) 1
  • user interface
    • restoring to original settings 1
  • user interface (UI) 1 , 2
    • unit testing 1
  • UserReports.xml 1
  • users
    • creating and editing 1
  • Use Windows Authentication connection option 1
  • using 1
  • UT_REPO_ADMINISTRATOR role 1
  • UT_REPO_USER role 1

V

  • variable substitution
    • unit testing 1
  • versioning
    • preferences for 1
    • SQL Developer support for 1
  • viewlets
    • SQL Developer 1
  • views 1
    • compiling 1
    • creating and editing 1
    • FROM clause 1
    • GROUP BY clause 1
    • HAVING clause 1
    • options when creating or editing 1
    • ORDER BY clause 1
    • recompiling 1
    • SELECT clause 1
    • splitting the data pane 1
    • WHERE clause 1

W

  • watches 1
  • WHERE clause 1
  • window groups (Scheduler) 1
    • creating and editing 1
  • windows (Scheduler) 1
    • creating and editing 1
  • Windows authentication
    • Use Windows Authentication connection option 1

X

  • XML DB Repository 1
  • XML schema 1
    • creating 1 , 2
  • xUnit frameworks 1

Z

  • zero date handling
    • MySQL connections 1