Go to main content
1/15
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Product Accessibility
Related Documents
Conventions
Third-Party License Information
ActiveDBSoft
Antlr 2.7.6, 3.1.3
Apache Commons Logging 1.0.4, 1.1
Apache Geronimo JMS 1.1 Specification 1.0, 1.1
Apache POI 3.10.1
ASM 5.0.4
Bouncy Castle Crypto API 1.45
Commons HttpClient 4.2.6
dom4j 1.6.1
HttpComponents
iText OEM Desktop 5.5.3
Jackson 1.9.3, 2.8.5
JGoodies Looks 1.3.1
jGraphX.jar 2.1.0.9
JLine 2.12.1
JSch 0.1.51
JXLayer 4.0
JZlib 1.1.3
Log4j 1.2.8, 1.2.13, 1.2.15, 1.2.17, 1.3
POI 2.5.1
Regular Expression Package 1.3
StringTemplate 3.1
SVNKit 1.0.0, 1.3.0
1
SQL Developer Concepts and Usage
1.1
About SQL Developer
1.2
Installing and Getting Started with SQL Developer
1.3
SQL Developer User Interface
1.3.1
Menus for SQL Developer
1.3.2
Restoring the Original "Look and Feel"
1.4
Database Objects
1.4.1
Applications (Application Express 3.0.1 and Later)
1.4.2
Cache Groups (Oracle TimesTen In-Memory Database)
1.4.3
Chains
1.4.4
Credentials
1.4.5
Database Destinations
1.4.6
Database Links (Public and Private)
1.4.7
Destination Groups
1.4.8
Directories
1.4.9
Editions
1.4.10
File Watchers
1.4.11
Functions
1.4.12
Indexes
1.4.13
Java Sources
1.4.14
Jobs
1.4.15
Job Classes
1.4.16
Operators
1.4.17
Materialized Views
1.4.18
Materialized View Logs
1.4.19
Multitenant Container Database (CDB)
1.4.20
Packages
1.4.21
Procedures
1.4.22
Programs
1.4.23
Queues
1.4.24
Queue Tables
1.4.25
Recycle Bin
1.4.26
Replication Schemes (Oracle TimesTen In-Memory Database)
1.4.27
Schedules
1.4.28
Sequences
1.4.29
Synonyms (Public and Private)
1.4.30
Tables
1.4.30.1
Flashback Table Support
1.4.31
Triggers
1.4.32
Types
1.4.33
Users (Other Users)
1.4.34
Views
1.4.35
Window Groups
1.4.36
Windows
1.4.37
XML DB Repository
1.4.38
XML Schemas
1.4.39
Captured and Converted Database Objects (for Migration)
1.5
Database Connections
1.5.1
Using Folders to Group Connections
1.5.2
Sharing of Connections
1.5.3
Advanced Security for JDBC Connection to the Database
1.5.4
Connections with Operating System (OS) Authentication
1.5.5
Connections with Proxy Authentication
1.5.6
Connections with SSH Authentication
1.6
Entering and Modifying Data
1.7
Running and Debugging Functions and Procedures
1.7.1
Using Bookmarks When Editing Functions and Procedures
1.7.2
Remote Debugging
1.7.3
Displaying SQL Trace (.trc) Files
1.7.4
Using the PL/SQL Hierarchical Profiler
1.7.5
Setting Expression Watches
1.8
Using the SQL Worksheet
1.8.1
SQL*Plus Statements Supported in SQL Worksheet
1.8.2
Script Runner
1.8.3
Execution Plan
1.8.4
Autotrace Pane
1.8.5
DBMS Output Pane
1.8.6
OWA Output Pane
1.8.7
SQL History
1.8.8
Query Builder
1.8.9
Command-Line Interface for SQL Formatting
1.8.10
SQL Worksheet "Hints" for Formatting Output
1.8.11
Gauges: In the SQL Worksheet and User-Defined Reports
1.8.12
Entering OLAP DML Statements in the SQL Worksheet
1.9
Using Snippets to Insert Code Fragments
1.9.1
User-Defined Snippets
1.10
Finding Database Objects
1.11
Using Recent Objects
1.12
Using Versioning
1.12.1
About Subversion and SQL Developer
1.12.2
Pending Changes
1.13
Using DBA Features in SQL Developer
1.13.1
Container Database (CDB)
1.13.2
Database Configuration
1.13.2.1
Initialization Parameters
1.13.2.2
Automatic Undo Management
1.13.2.3
Current Database Properties
1.13.2.4
Restore Points
1.13.2.5
View Database Feature Usage
1.13.3
Database Status
1.13.3.1
Status
1.13.3.2
DB Instance
1.13.3.3
Instance Viewer
1.13.4
Data Guard
1.13.5
Data Pump
1.13.5.1
Export Jobs
1.13.5.2
Import Jobs
1.13.6
Oracle Sharding
1.13.7
Performance
1.13.7.1
Snapshots
1.13.7.2
Baselines
1.13.7.3
Baseline Templates
1.13.7.4
Automatic Database Diagnostic Monitor (ADDM)
1.13.7.5
ASH (Active Session History) Report Viewer
1.13.7.6
AWR (Automatic Workload Repository)
1.13.8
RMAN Backup/Recovery
1.13.8.1
Backup Jobs
1.13.8.2
Backup Sets
1.13.8.3
Image Copies
1.13.8.4
RMAN Settings
1.13.8.5
Scheduled RMAN Actions
1.13.8.6
Using Action Jobs
1.13.9
Resource Manager
1.13.9.1
Consumer Group Mappings
1.13.9.2
Consumer Groups
1.13.9.3
Plans
1.13.9.4
Settings
1.13.9.5
Statistics
1.13.10
SQL Translator FrameWork
1.13.10.1
SQL Translator Profiles
1.13.10.2
SQL Translators
1.13.11
Scheduler
1.13.11.1
Global Attributes
1.13.11.2
Job Classes
1.13.11.3
External Destinations
1.13.12
Security
1.13.12.1
Audit Settings
1.13.12.2
Profiles
1.13.12.3
Roles
1.13.12.4
Users
1.13.13
Storage
1.13.13.1
Archive Logs
1.13.13.2
Control Files
1.13.13.3
Datafiles
1.13.13.4
Redo Log Groups
1.13.13.5
Rollback Segments
1.13.13.6
Tablespaces
1.13.13.7
Temporary Tablespace Groups
1.13.14
Tuning
1.13.14.1
Real Time SQL Monitor
1.14
Scheduling Jobs Using SQL Developer
1.14.1
Scheduler Design Editor
1.15
Using the Cart
1.15.1
Adding Data Files to the Cart
1.15.2
Cart Versus Database Export Wizard
1.16
Spatial Support in SQL Developer
1.16.1
Context Menu Operations on Spatial Data and Metadata
1.16.2
Map Visualization of Spatial Data
1.16.2.1
Visualizing Geometries by Creating and Executing a Query
1.16.2.2
Visualizing Geometries from the Table Data Grid
1.17
Change Manager Support in SQL Developer
1.17.1
Change Plan Administrators and Developers
1.17.2
Developing Change Plans with SQL Developer
1.17.2.1
Creating a Repository Connection
1.17.2.2
Creating and Deleting Change Plans
1.17.2.3
Adding and Updating Change Items
1.17.2.4
Using Change Plans to Capture Change in SQL Developer
1.17.3
Change Manager Actions to Perform with Enterprise Manager
1.17.3.1
Creating Change Plans from Change Manager Schema Comparisons
1.17.3.2
Deploying Change Plans
1.18
Apache Hadoop Connectors Support in SQL Developer
1.18.1
Copy to Hadoop: Overview and Requirements
1.18.2
Oracle Loader for Hadoop: Overview and Requirements
1.18.3
Oracle SQL Connector for HDFS: Overview and Requirements
1.19
SQL Developer Reports
1.19.1
Bind Variables for Reports
1.19.2
About Your Database reports
1.19.3
All Objects reports
1.19.4
Application Express reports
1.19.5
ASH and AWR reports
1.19.6
Charts reports
1.19.7
Database Administration reports
1.19.8
Data Dictionary reports
1.19.9
Scheduler reports
1.19.10
PL/SQL reports
1.19.11
Security reports
1.19.12
Streams reports
1.19.13
Table reports
1.19.13.1
Quality Assurance reports
1.19.14
XML reports
1.19.15
Data Modeler reports
1.19.16
User Defined reports
1.19.16.1
User-Defined Report Example: Chart
1.19.16.2
User-Defined Report Example: Dynamic HTML
1.20
SQL Developer Preferences
1.20.1
Environment
1.20.2
Change Management Parameters
1.20.3
Code Editor
1.20.4
Compare and Merge
1.20.5
Database
1.20.6
Debugger
1.20.7
External Editor
1.20.8
File Types
1.20.9
Global Ignore List
1.20.10
Migration
1.20.11
Mouse Actions
1.20.12
Shortcut Keys (Accelerator Keys)
1.20.13
SSH (Secure Shell)
1.20.14
Unit Test Parameters
1.20.15
Usage Reporting
1.20.16
Versioning
1.20.16.1
Versioning: Git
1.20.16.2
Versioning: Subversion
1.20.16.3
Versioning: CVS
1.20.16.4
Versioning: Perforce
1.20.17
Web Browser and Proxy
1.20.18
XML Schemas
1.21
Location of User-Related Information
1.22
Java Development Kit (JDK) Location
1.23
Command-Line Interface for SQL Developer
1.24
Data Modeler in SQL Developer
1.25
Oracle TimesTen In-Memory Database Support
1.26
Using the Help
1.27
SQL Developer Usage Suggestions
1.27.1
SQL History Shortcuts
1.27.2
Unshared Worksheets
1.27.3
SQL Worksheet Bookmarks
1.27.4
Oracle Data Miner
1.27.5
Formatted Display of SQL Trace (.trc) Files
1.27.6
Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
1.27.7
Folders for Organizing Connections
1.27.8
Third-Party Databases and SQL Developer
1.27.9
Debugger Ports and Firewalls
1.27.10
Viewing Multiple Tables
1.27.11
Customizing SQL Developer Appearance
1.27.12
Maximizing Tab Panes
1.27.13
Default Path for Running Scripts
1.27.14
Shutting Down and Restarting the Database
1.27.15
Feature Requests
1.27.16
Discussion Forums
1.27.17
Help Text Font Size
1.27.18
Procedure and Function Signatures
1.27.19
Type-Ahead in Navigators
1.27.20
Extended Paste
1.27.21
Closing Tabbed Windows Using the Mouse Wheel
1.27.22
Go to Last Edit Location
1.27.23
Closing Tabbed Windows Using the Context Menu
1.27.24
List of All Open Windows
1.27.25
Go to Subprogram Implementation from Package Window
1.27.26
Select Multiple Table or Column Names in Completion Insight
1.27.27
Startup Time and Automatic Check for Updates
1.28
For More Information About SQL Developer
2
SQL Developer: Migrating Third-Party Databases
2.1
Migration: Basic Options and Steps
2.1.1
Migrating Using the Migration Wizard
2.1.1.1
Repository
2.1.1.2
Project
2.1.1.3
Source Database
2.1.1.4
Capture
2.1.1.5
Convert
2.1.1.6
Translate
2.1.1.7
Target Database
2.1.1.8
Move Data
2.1.1.9
Summary
2.1.2
Copying Selected Tables to Oracle
2.2
Migration: Background Information and Guidelines
2.2.1
Overview of Migration
2.2.1.1
Migration Implemented as SQL Developer Extensions
2.2.2
Preparing a Migration Plan
2.2.2.1
Task 1: Determining the Requirements of the Migration Project
2.2.2.2
Task 2: Estimating Workload
2.2.2.3
Task 3: Analyzing Operational Requirements
2.2.2.4
Task 4: Analyzing the Application
2.2.2.5
Task 5: Planning the Migration Project
2.2.3
Before You Start Migrating: General Information
2.2.3.1
Creating a Database User for the Migration Repository
2.2.3.2
Requirements for Creating the Destination Oracle Objects
2.2.4
Before You Start Migrating: Source-Specific Information
2.2.4.1
Before Migrating From IBM DB2
2.2.4.2
Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
2.2.4.3
Before Migrating From MySQL
2.2.4.4
Before Migrating From Teradata
2.2.5
Capturing the Source Database
2.2.5.1
Offline Capture
2.2.5.1.1
IBM DB2 Offline Capture Notes
2.2.6
Creating and Customizing the Converted Model
2.2.6.1
Correcting Errors in the Converted Model
2.2.7
Generating the DDL for the Oracle Schema Objects
2.2.8
Migrating the Data
2.2.8.1
Transferring the Data Offline
2.2.8.1.1
Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
2.2.8.1.2
Creating Data Files From MySQL
2.2.8.1.3
Populating the Destination Database Using the Data Files
2.2.9
Making Queries Case Insensitive
2.2.10
Testing the Oracle Database
2.2.10.1
Testing Methodology
2.2.10.2
Testing the Oracle Database
2.2.10.2.1
Guidelines for Creating Tests
2.2.10.2.2
Example of a Unit Test Case
2.2.11
Deploying the Oracle Database
2.2.11.1
Choosing a Rollout Strategy
2.2.11.1.1
Phased Approach
2.2.11.1.2
Big Bang Approach
2.2.11.1.3
Parallel Approach
2.2.11.2
Deploying the Destination Database
2.3
SQL Developer User Interface for Migration
2.3.1
Migration Submenu
2.3.2
Other Menus: Migration Items
2.3.3
Migration Preferences
2.3.4
Migration Log Panes
2.3.5
Using the Translation Scratch Editor
2.4
Command-Line Interface for Migration
3
SQL Developer: Oracle REST Data Services Support
3.1
Installing Oracle REST Data Services
3.2
Oracle REST Data Services Administration
3.2.1
About Oracle REST Data Services
3.2.2
Oracle REST Data Services Administration Toolbar and Context Menu
3.2.3
Connecting to Oracle REST Data Services
3.2.4
REST Data Services Navigator: Global Settings and Database Settings
3.2.4.1
Connections
3.2.4.2
Default Password
3.2.4.3
ORDS Public User (Database Settings Only)
3.2.4.4
PL/SQL Gateway User (Database Settings Only)
3.2.4.5
APEX REST Users (Database Settings Only)
3.2.4.6
Security
3.2.4.7
Cache Files
3.2.4.8
Environment
3.2.4.9
Excel
3.2.5
REST Data Services Navigator: NoSQL Store Configuration
3.2.6
REST Data Services Navigator: Reports
3.3
Automatically Enabling REST Access to a Schema, Table, or View (AutoREST)
3.4
REST Development
3.4.1
About RESTful Services
3.4.2
RESTful Services Terminology
3.4.3
RESTful Services Requirements and Setup
3.4.4
REST Data Services in the Connections Navigator
3.4.5
REST Development Pane
4
SQL Developer: Unit Testing
4.1
Overview of Unit Testing
4.2
SQL Developer User Interface for Unit Testing
4.2.1
Unit Test Submenu
4.2.2
Other Menus: Unit Test Items
4.2.3
Unit Test Preferences
4.3
Unit Test Repository
4.3.1
Managing Repository Users and Administrators
4.4
Editing and Running a Unit Test
4.5
Using a Dynamic Value Query to Create a Unit Test
4.6
Using Lookups to Simplify Unit Test Creation
4.6.1
Providing Values for Input Fields
4.6.2
Automatically Creating Implementations
4.7
Using Variable Substitution in Validation Actions
4.8
Unit Test Library
4.9
Unit Test Reports
4.10
Exporting and Importing Unit Test Objects
4.11
Command-Line Interface for Unit Testing
4.12
Unit Testing Best Practices
4.12.1
Strategy
4.12.2
Test Suites
4.12.3
Test Naming
4.12.4
Avoiding Test Naming Clashes
4.12.5
Test Implementations
4.12.6
Library
4.12.7
Lookups
4.12.8
Test and Suite Execution
4.12.9
Reports
4.13
Example of Unit Testing (Tutorial)
4.13.1
Create the EMPLOYEES Table
4.13.2
Create the AWARD_BONUS Procedure
4.13.3
Create the Unit Testing Repository
4.13.4
Create a Unit Test
4.13.5
Run the Unit Test
4.13.6
Create and Run an Exception Unit Test
4.13.7
Create a Unit Test Suite
4.13.8
Run the Unit Test Suite
5
SQL Developer Tutorial: Creating Objects for a Small Database
5.1
Create a Table (BOOKS)
5.2
Create a Table (PATRONS)
5.3
Create a Table (TRANSACTIONS)
5.4
Create a Sequence
5.5
Insert Data into the Tables
5.6
Create a View
5.7
Create a PL/SQL Procedure
5.8
Debug a PL/SQL Procedure
5.9
Use the SQL Worksheet for Queries
5.10
Script for Creating and Using the Library Tutorial Objects
6
SQL Developer Dialog Boxes and Wizards
6.1
Add Extension
6.2
Add Schema Error
6.3
Advanced Properties (Connections)
6.3.1
Proxy tab
6.4
Application Migration
6.5
Associate Repository
6.6
Cart Error (Objects Not Available)
6.7
Change Type
6.8
Check for Updates
6.9
Choose Configuration File Option
6.10
Choose Directory
6.11
Clone PDB to Oracle Cloud
6.12
Clone Pluggable Database
6.13
Color Palette and Custom Colors
6.14
Configure Extension
6.15
Configure File Type Associations
6.16
Copy Columns
6.17
Copy Objects
6.18
Copy to Hadoop / Append to Hadoop Table
6.19
Copy to Oracle
6.20
Component Palette
6.21
Component Palette: Configure Component Palette
6.22
Component Palette: Create Palette Page
6.23
Component Palette: New/Edit Code Snippet
6.24
Component Palette: New Section/Rename Section
6.25
Confirm Drop Application
6.26
Confirm Running SQL
6.27
Connection Has Uncommitted Changes
6.28
Create New Object
6.29
Create/Edit Chain
6.30
Create/Edit Credential
6.31
Create/Edit/Select Database Connection
6.31.1
Oracle tab
6.31.2
TimesTen tab
6.31.3
Amazon Redshift tab
6.31.4
DB2 tab
6.31.5
Hive tab
6.31.6
JDBC tab
6.31.7
MySQL tab
6.31.8
PostgreSQL tab
6.31.9
SQL Server and Sybase tab
6.31.10
Teradata tab
6.31.11
Creating and Editing Connections
6.32
New/Edit Cloud Connection
6.32.1
Advanced Connection Information
6.33
New/Edit NoSQL Connection
6.34
Rename Model (Migration)
6.35
Delete Confirmation
6.36
Delete Confirmation (Migration)
6.37
Rename Database Item (Migration)
6.38
Select Connection
6.39
Connection Information
6.40
No Connection Found
6.41
Connection Rename Error
6.42
New Folder (Connections)
6.43
Continue After Pause
6.44
Select Library
6.45
Create Library
6.46
CVS: Check Out from CVS
6.47
CVS: Create/Edit CVS Connection
6.48
CVS: Import to CVS
6.49
CVS: Log In to CVS
6.50
Data Import Wizard (Load Data)
6.50.1
Data Preview
6.50.2
Import Method
6.50.3
Choose Columns
6.50.4
Column Definition
6.50.5
Finish
6.51
Export/Import Connections
6.51.1
Export Connections
6.51.2
Import Connections
6.52
Create/Edit Database Destination
6.53
Create/Edit Destination Group (Database or External)
6.54
Create/Edit Database Link
6.55
Create/Edit Index
6.55.1
Definition
6.55.2
Properties
6.55.3
Storage
6.55.4
Partitions
6.55.5
DDL
6.56
Create File Watcher
6.57
Create Filter
6.58
Create Function or Procedure
6.59
Create/Edit Job
6.59.1
Job Details
6.59.2
Destination
6.59.3
Job Arguments
6.59.4
Notification
6.59.5
Properties
6.59.6
Summary/SQL
6.60
Create/Edit Job Class
6.61
Create/Edit Materialized View Log
6.62
Create PL/SQL Package
6.63
Create Pluggable Database
6.64
Create/Edit Program
6.65
Create/Edit Role
6.66
Create/Edit Schedule
6.67
Create/Edit Sequence
6.68
Create SQL File
6.69
Create/Edit Synonym
6.70
Create Table (quick creation)
6.71
Create/Edit Table (with advanced options)
6.71.1
Columns pane
6.71.2
Constraints
6.71.3
Primary Key Constraint
6.71.4
Unique Constraints
6.71.5
Foreign Keys Constraints
6.71.6
Check Constraints
6.71.7
Indexes pane
6.71.8
In-Memory pane
6.71.9
Storage pane
6.71.10
Column Sequences pane
6.71.11
Table Properties pane
6.71.12
LOB Parameters pane
6.71.13
Partitioning pane
6.71.14
Subpartition Templates pane
6.71.15
Partition Definitions pane
6.71.16
Index Organized Properties pane
6.71.17
External Table Properties pane
6.71.18
Comment pane
6.71.19
DDL pane
6.71.20
Hive Tables
6.71.20.1
Hive Tables: Partitions
6.71.20.2
Hive Tables: Buckets
6.71.20.3
Hive Tables: Skew
6.71.20.4
Hive Tables: Storage
6.71.20.5
Hive Tables: Table Properties
6.72
Storage Options
6.73
Create/Edit Tablespace
6.73.1
File Specifications tab
6.73.2
Properties tab
6.73.3
Default Parameters tab
6.73.4
DDL tab
6.74
Create Trigger
6.75
Create Type (User-Defined)
6.76
Create/Edit User
6.76.1
User tab
6.76.2
Granted Roles tab
6.76.3
System Privileges tab
6.76.4
Quotas tab
6.76.5
SQL tab
6.77
Create/Edit User Defined Report
6.78
Create/Edit User Defined Report Folder
6.79
Create/Edit View
6.79.1
SQL Query tab or pane
6.79.2
View Properties or Materialized View Properties pane
6.79.3
DDL tab or pane
6.79.4
Quick-Pick Objects pane
6.79.5
FROM Clause pane
6.79.6
SELECT Clause pane
6.79.7
WHERE Clause pane
6.79.8
GROUP BY Clause pane
6.79.9
HAVING Clause pane
6.79.10
ORDER BY Clause pane
6.80
Create Window
6.81
Create Window Group
6.82
Create XML Document from XML Schema
6.83
Create XML Schema
6.84
Custom Filters
6.85
Customize Toolbars
6.86
Data Pump Export
6.86.1
Source page
6.86.2
Tablespaces page
6.86.3
Schemas page
6.86.4
Tables page
6.86.5
Filter page
6.86.6
Table Data page
6.86.7
Options page
6.86.8
Output Files page
6.86.9
Job Schedule page
6.86.10
Summary page
6.87
Data Pump Import
6.87.1
Type page
6.87.2
Tablespaces page
6.87.3
Schemas page
6.87.4
Tables page
6.87.5
Filter page
6.87.6
Table Data page
6.87.7
Remapping page
6.87.8
Options page
6.87.9
Job Schedule page
6.87.10
Summary page
6.88
Database Copy
6.88.1
Source/Destination page
6.88.2
Object Types page
6.88.3
Select Schemas page
6.88.4
Select Tablespace page
6.88.5
Specify Objects page
6.88.6
Specify Data page
6.88.7
Summary page
6.89
Database Differences
6.89.1
Source/Destination page
6.89.2
Types to Diff page
6.89.3
Specify Objects page
6.89.4
Summary page
6.90
Database Export (Unload Database Objects and Data)
6.90.1
Source/Destination page
6.90.2
Types to Export page
6.90.3
Specify Objects page
6.90.4
Specify Data page
6.90.5
Export Summary page
6.91
DDL Panel for Creating or Editing an Object
6.92
Debugger - Attach to JPDA
6.93
Deploy or Import Application
6.94
Deploy Objects to Cloud
6.94.1
Cloud
6.94.2
Authorization
6.94.3
Transfer
6.94.4
Deploy DDL
6.94.5
Deploy Data
6.94.6
Unsupported Cart Object for Cloud Deployment
6.94.7
Other Errors (Invalid or Missing Entries)
6.95
Describe Object Window
6.96
Diff Objects
6.97
Drop Pluggable Database
6.98
Drop REST Services for Schema
6.99
Edit/View Value (Data or Table Column)
6.100
Enter Bind Values
6.101
Erase from Disk
6.102
Error Writing to Export File
6.103
Export Error
6.104
Export Data
6.105
Export Objects
6.106
Export Resource Module, Privilege, and Role
6.107
Export: Unique Names Warning
6.108
External Locator Configuration
6.109
External Tools
6.110
Create/Edit External Tool
6.110.1
Program Options
6.110.2
Display
6.110.3
Integration
6.110.4
Availability
6.111
Choose Offline Options
6.112
Edit Font Location
6.113
Edit Header or Footer (PDF Formatting)
6.114
Edit Join
6.115
Feature Missing
6.116
Feature Required
6.117
File Processing
6.118
Filter
6.119
Filter Object Types
6.120
Filter Schemas
6.121
Filter Error
6.122
Find/Highlight
6.123
Git: Add
6.124
Git: Add All
6.125
Git: Add to .gitignore File
6.126
Git: Checkout Revision
6.127
Git: Clone from Git
6.128
Git: Commit
6.129
Git: Commit All
6.130
Git: Create Branch
6.131
Git: Create Tag
6.132
Git: Export Committed Changes
6.133
Git: Export Uncommitted Changes
6.134
Git: Fetch from Git
6.135
Git: Initialize Repository
6.136
Git: Merge
6.137
Git: Pull from Git
6.138
Git: Push to Git
6.139
Git: Revert
6.140
Insert Macro
6.141
Externally Modified Files
6.142
Find/Replace Text
6.143
Find Result
6.144
Format Properties (Advanced Formatting)
6.145
Generate Patch
6.146
Go to Bookmark
6.147
Go to Line Number
6.148
Go to Line Number: Error
6.149
History
6.150
Import Using Oracle Loader for Hadoop
6.151
Import Using Oracle SQL Connector for HDFS
6.152
Install/Run Oracle REST Data Services
6.152.1
ORDS File Locations
6.152.2
Database Connection
6.152.3
Database Options
6.152.4
Select Tablespace
6.152.5
PL/SQL Gateway
6.152.6
APEX RESTful Services
6.152.7
Run Standalone Mode
6.152.8
ORDS Users
6.152.9
Summary
6.153
Install SQL Translator
6.153.1
Installing a Translator and Creating a Profile: Usage Notes
6.154
Invalid Database Version
6.155
Load Extension
6.156
Load Keyboard Scheme
6.157
LOB Descriptors
6.158
Maintain Spatial Metadata
6.159
Manage Columns
6.160
Manage Connections (REST)
6.161
Manage Features and Updates
6.162
Map Connection
6.163
Merge Migration Projects
6.164
Modify Pluggable State
6.165
Modify Value
6.166
Data Move Details
6.167
New/Edit Change Set
6.168
New Procedure (Refactoring)
6.169
New/Edit Local or Remote Port Forward
6.170
Edit SSH Connection
6.171
No Lock
6.172
No Object Found
6.173
No Object Selected
6.174
Object Preferences
6.175
Offline Generation Error - Destination Directory
6.176
Open File
6.177
Oracle-Only Report
6.178
Paste
6.179
Perforce: Add Files to Perforce
6.180
Perforce: Connection
6.181
Perforce: Create Changelist
6.182
Perforce: Delete Files
6.183
Perforce: Login
6.184
Perforce: Open Files for Edit
6.185
Perforce: Revert Files
6.186
Perforce: Sync Files
6.187
Perforce: Submit Changelist
6.188
Plug In Pluggable Database
6.189
Print Preview
6.190
Privilege Warning for Migration
6.191
Publish to REST
6.192
Recent Files
6.193
Delete or Truncate Repository
6.193.1
Error Truncating Repository
6.194
Rename Local Variable
6.195
Rename Tab
6.196
Rename Procedure
6.197
Repair (Validate) Oracle REST Data Services
6.198
REST Data Services Connection
6.199
REST Data Services Connection: Authentication Failed
6.200
REST Data Services Connection: Remove Connection
6.201
RESTful Services Wizard (Auto-Enable REST Access)
6.201.1
Specify Details
6.201.2
RESTful Summary
6.202
RESTful Services Wizard and Object Dialog Boxes
6.202.1
Resource Module
6.202.2
Resource Template
6.202.3
Resource Handler
6.202.3.1
Resource Handler Editing Pane
6.202.4
RESTful Summary
6.203
RESTful Services Connection
6.204
RESTful Services Privilege
6.205
RESTful Services Roles
6.206
Select Current Repository
6.207
Cannot Capture Table
6.208
Report Panel
6.209
Reset Expired Password (Enter New Password)
6.210
Revision Lister
6.211
Run/Debug/Profile PL/SQL
6.212
Create/Edit Breakpoint
6.212.1
Definition tab
6.212.2
Conditions tab
6.212.3
Actions tab
6.213
Save/Save As, or Select File
6.214
Save or Open Cart Tool Configuration
6.215
Save Files
6.216
Unable to Save Files
6.217
Save Style Settings
6.218
Schema Differences Source or Destination Error
6.219
Script Execution Failed
6.220
Script Generation Complete
6.221
Set Data Mapping
6.222
Add/Edit Rule
6.223
Set Encoding
6.224
Set Pause Continue
6.225
Shared Wizard Pages
6.225.1
Types
6.225.2
Specify Objects
6.225.3
Data
6.225.4
Summary
6.226
Sign In (checking for updates)
6.227
Single Record View
6.228
Save Snippet (User-Defined)
6.229
Edit Snippets (User-Defined)
6.230
Show SQL
6.231
Start Date, End Date, Repeat Interval, Comments (Scheduler)
6.232
Subversion: Add Property
6.233
Subversion: Add to Source Control
6.234
Subversion: Apply Patch
6.235
Subversion: Branch/Tag
6.236
Subversion: Check Out from Subversion
6.237
Subversion: Commit Resources
6.238
Subversion: Commit Working Copy
6.239
Subversion: Confirm Checkout
6.240
Subversion: Create Remote Directory
6.241
Subversion: Create Subversion Repository
6.242
Subversion: Create/Edit Subversion Connection
6.243
Subversion: Delete Resources
6.244
Subversion: Edit Configuration File
6.245
Subversion: Export Files
6.246
Subversion: Export Subversion Connections
6.247
Subversion: Ignore
6.248
Subversion: Import Subversion Connections
6.249
Subversion: Import to Subversion
6.249.1
Destination
6.249.2
Source
6.249.3
Filters
6.249.4
Options
6.249.5
Summary
6.250
Subversion: Lock Resources
6.251
Subversion: Merge
6.252
Subversion: Pending Changes
6.253
Subversion: Properties
6.254
Subversion: Remove from Subversion
6.255
Subversion: Repository Browser
6.256
Subversion: Revert Local Changes
6.257
Subversion: Switch
6.258
Subversion: Unlock Resources
6.259
Subversion: Update Resources
6.260
Subversion: Update Working Copy
6.261
Subversion: Versioning Properties
6.262
Third-Party Database Objects
6.263
Unable to Connect
6.264
Unable to Open File
6.265
Uninstall Oracle REST Data Services
6.266
Unit Testing: Action Required
6.267
Unit Testing: Add Category
6.268
Unit Testing: Add Data Type
6.269
Unit Testing: Add Item to Library
6.270
Unit Testing: Add Test Implementation
6.271
Unit Testing: Add Test Suite
6.272
Unit Testing: Add Tests or Suites to a Suite
6.273
Unit Testing: Copy or Rename Unit Test
6.274
Unit Testing: Create Unit Test
6.274.1
Select Operation
6.274.2
Specify Test Name
6.274.3
Specify Startup
6.274.4
Specify Parameters
6.274.5
Specify Validations
6.274.6
Specify Teardown
6.274.7
Summary
6.275
Unit Testing: Manage Users
6.276
Unit Testing: Rename Test Implementation
6.277
Unit Testing: Result of Operation
6.278
Unit Testing: Synchronize Unit Test
6.279
Unplug Pluggable Database
6.280
Unsupported Database Version
6.281
Validate Geometry
6.282
View Whole Value
6.283
Windows
6.284
XMLType Column Properties
7
SQL Developer: TimesTen Support
7.1
Create a New TimesTen Connection
7.1.1
DSN
7.1.2
Easy Client/Server
7.1.3
Advanced
7.2
Set the Cache Administrator User Name and Password
7.3
Start and Stop the Cache Agent
7.4
Create a Cache Group
7.4.1
Defining a cache group and cache table attributes
7.4.2
Defining the root table
7.4.2.1
Selecting the columns to cache
7.4.2.2
Specifying the table attributes
7.4.2.3
Specifying an aging policy
7.4.2.4
Verifying the root table definition
7.4.3
Defining the child tables
7.4.3.1
Selecting the columns to cache
7.4.3.2
Specifying the table attributes
7.4.3.3
Completing the definitions of the child tables
7.4.3.4
Verifying the cache group definition
7.5
Drop a Cache Group
7.6
Load or Refresh a Cache Group
7.7
Flush a Cache Group
7.8
Unload a Cache Group
7.9
Alter the Automatic Refresh Attributes of a Cache Group
7.10
Specify and Display LOB Data Types
7.11
Specify the INLINE Attribute for Columns
7.12
Compute Table Size
7.13
Use a REF CURSOR as an OUTPUT Parameter
7.14
Create an Index on a TimesTen Table
7.15
Create a Primary Key Constraint
7.16
Change the Attributes of Primary Key
7.17
Create a Foreign Key Constraint
7.18
Drop a Constraint
7.19
Add an Aging Policy to a Table
7.20
Drop an Aging Policy from a Table
7.21
Change the Aging State for the Aging Policy of a Table
7.22
Change the Memory Usage Thresholds and LRU Aging Cycle
7.23
Change the Lifetime and Cycle for the Time-Based Aging Policy of a Table
7.24
Grant Object Privileges to a TimesTen Database Element
7.25
Revoke Object Privileges from a TimesTen Database Element
7.26
Load Data into a Table
7.27
Start and Stop the TimesTen Replication Agent
7.28
Update the Table and Column Statistics Used By the TimesTen Query Optimizer
7.29
Export the Table Statistics Used By the TimesTen Query Optimizer
7.30
Create a TimesTen Performance Metrics Snapshot
7.31
Drop a TimesTen Performance Metrics Snapshot
7.32
Edit the TimesTen Performance Metrics Configuration
7.33
Create a TimesTen Performance Metrics Report
7.33.1
Save a report
7.34
Capture Data for the TimesTen Index Advisor at the Connection Level
7.34.1
Capture data from a SQL worksheet
7.34.1.1
Saving index recommendations from a SQL worksheet
7.34.2
Capture data from a SQL workload script
7.35
Capture Data for the TimesTen Index Advisor at the Database Level
7.36
View the TimesTen Index Advisor Capture State
7.37
Load Data from an Oracle Database into a TimesTen Database
7.38
Load Data from an Oracle Database Table into an Existing TimesTen Table
8
SQL Developer Accessibility Information
8.1
About Oracle SQL Developer Accessibility
8.2
Using a Screen Reader and Java Access Bridge with Oracle SQL Developer
8.3
Oracle SQL Developer Features that Support Accessibility
8.3.1
Keyboard Access
8.3.2
Screen Reader Readability
8.3.3
Flexibility in Font and Color Choices
8.3.4
No Audio-only Feedback
8.3.5
No Dependency on Blinking Cursor and Animation
8.3.6
Screen Magnifier Usability
8.3.7
How to Change the Editor or Tabbed View of a File
8.3.8
How to Read Text in a Multiline Edit Field
8.3.9
How to Read the Line Number in the Source Editor
8.3.10
How to Access Exception Stack HTML Links and Generated Javadoc Links in the Log Window
8.4
Recommendations for Customizing Oracle SQL Developer
8.4.1
How to Customize the Accelerators Keys
8.4.2
How to Pass a Conflicting Accelerator Key to Oracle SQL Developer
8.4.3
How to Change the Look and Feel of SQL Developer
8.4.4
How to Customize the Fonts in Code Editors
8.4.5
How to Customize Syntax Highlighting
8.4.6
How to Display Line Numbers in Code Editors
8.4.7
How to Change the Timing for Completion Insight
8.4.8
How to Specify the Columns in the Debugger
8.5
Highly Visual Features of Oracle SQL Developer
Index
Scripting on this page enhances content navigation, but does not change the content in any way.