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
Antlr 3.1.3
Batik Version 1.7
Bouncy Castle Crypto API 1.45
JGoodies Looks 1.3.1
JXLayer 4.0
Log4j 1.2.9
POI 2.5.1
Regular Expression Package 1.3
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
Materialized Views
1.4.17
Materialized View Logs
1.4.18
Multitenant Container Database (CDB)
1.4.19
Packages
1.4.20
Procedures
1.4.21
Programs
1.4.22
Queues
1.4.23
Queue Tables
1.4.24
Recycle Bin
1.4.25
Replication Schemes (Oracle TimesTen In-Memory Database)
1.4.26
Schedules
1.4.27
Sequences
1.4.28
Synonyms (Public and Private)
1.4.29
Tables
1.4.29.1
Flashback Table Support
1.4.30
Triggers
1.4.31
Types
1.4.32
Users (Other Users)
1.4.33
Views
1.4.34
Window Groups
1.4.35
Windows
1.4.36
XML DB Repository
1.4.37
XML Schemas
1.4.38
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 and Not 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 Pump
1.13.4.1
Export Jobs
1.13.4.2
Import Jobs
1.13.5
Performance
1.13.5.1
Snapshots
1.13.5.2
Baselines
1.13.5.3
Baseline Templates
1.13.5.4
Automatic Database Diagnostic Monitor (ADDM)
1.13.5.5
ASH (Active Session History) Report Viewer
1.13.5.6
AWR (Automatic Workload Repository)
1.13.6
RMAN Backup/Recovery
1.13.6.1
Backup Jobs
1.13.6.2
Backup Sets
1.13.6.3
Image Copies
1.13.6.4
RMAN Settings
1.13.6.5
Scheduled RMAN Actions
1.13.6.6
Using Action Jobs
1.13.7
Resource Manager
1.13.7.1
Consumer Group Mappings
1.13.7.2
Consumer Groups
1.13.7.3
Plans
1.13.7.4
Settings
1.13.7.5
Statistics
1.13.8
SQL Translator FrameWork
1.13.8.1
SQL Translator Profiles
1.13.8.2
SQL Translators
1.13.9
Scheduler
1.13.9.1
Global Attributes
1.13.9.2
Job Classes
1.13.9.3
External Destinations
1.13.10
Security
1.13.10.1
Audit Settings
1.13.10.2
Profiles
1.13.10.3
Roles
1.13.10.4
Users
1.13.11
Storage
1.13.11.1
Archive Logs
1.13.11.2
Control Files
1.13.11.3
Datafiles
1.13.11.4
Redo Log Groups
1.13.11.5
Rollback Segments
1.13.11.6
Tablespaces
1.13.11.7
Temporary Tablespace Groups
1.14
Scheduling Jobs Using SQL Developer
1.14.1
Scheduler Design Editor
1.15
Using the Cart
1.15.1
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
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 and Database Settings
3.2.4.1
Connections
3.2.4.2
Oracle REST Data Services Public User (Database Settings Only)
3.2.4.3
PL/SQL Gateway User
3.2.4.4
APEX REST Users (Database Settings only)
3.2.4.5
Security
3.2.4.6
Cache Files
3.2.4.7
Environment
3.2.4.8
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 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.3.2
SSH 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 Directory
6.10
Clone PDB to Oracle Cloud
6.11
Clone Pluggable Database
6.12
Color Palette and Custom Colors
6.13
Configure Extension
6.14
Configure File Type Associations
6.15
Copy Columns
6.16
Copy Objects
6.17
Copy to Hadoop / Append to Hadoop Table
6.18
Component Palette
6.19
Component Palette: Configure Component Palette
6.20
Component Palette: Create Palette Page
6.21
Component Palette: New/Edit Code Snippet
6.22
Component Palette: New Section / Rename Section
6.23
Confirm Drop Application
6.24
Confirm Running SQL
6.25
Connection Has Uncommitted Changes
6.26
Create New Object
6.27
Create/Edit Chain
6.28
Create/Edit Credential
6.29
Create/Edit/Select Database Connection
6.29.1
Oracle tab
6.29.2
TimesTen tab
6.29.3
DB2 tab
6.29.4
Hive tab
6.29.5
JDBC tab
6.29.6
MySQL tab
6.29.7
PostgreSQL tab
6.29.8
SQL Server and Sybase tab
6.29.9
Teradata tab
6.29.10
Creating and Editing Connections
6.30
New/Edit Cloud Connection
6.30.1
Advanced Connection Information
6.31
New/Edit NoSQL Connection
6.32
Rename Model (Migration)
6.33
Delete Confirmation
6.34
Delete Confirmation (Migration)
6.35
Rename Database Item (Migration)
6.36
Select Connection
6.37
Connection Information
6.38
No Connection Found
6.39
Connection Rename Error
6.40
New Folder (Connections)
6.41
Continue After Pause
6.42
Select Library
6.43
Create Library
6.44
CVS: Check Out from CVS
6.45
CVS: Create/Edit CVS Connection
6.46
CVS: Import to CVS
6.47
CVS: Log In to CVS
6.48
Data Import Wizard (Load Data)
6.48.1
Data Preview
6.48.2
Import Method
6.48.3
Choose Columns
6.48.4
Column Definition
6.48.5
Finish
6.49
Export/Import Connections
6.49.1
Export Connections
6.49.2
Import Connections
6.50
Create/Edit Database Destination
6.51
Create/Edit Destination Group (Database or External)
6.52
Create/Edit Database Link
6.53
Create/Edit Index
6.53.1
Definition
6.53.2
Properties
6.53.3
Storage
6.53.4
Partitions
6.53.5
DDL
6.54
Create File Watcher
6.55
Create Filter
6.56
Create Function or Procedure
6.57
Create/Edit Job
6.57.1
Job Details
6.57.2
Destination
6.57.3
Job Arguments
6.57.4
Notification
6.57.5
Properties
6.57.6
Summary/SQL
6.58
Create/Edit Job Class
6.59
Create/Edit Materialized View Log
6.60
Create PL/SQL Package
6.61
Create Pluggable Database
6.62
Create/Edit Program
6.63
Create/Edit Role
6.64
Create/Edit Schedule
6.65
Create/Edit Sequence
6.66
Create SQL File
6.67
Create/Edit Synonym
6.68
Create Table (quick creation)
6.69
Create/Edit Table (with advanced options)
6.69.1
Columns pane
6.69.2
Constraints
6.69.3
Primary Key Constraint
6.69.4
Unique Constraints
6.69.5
Foreign Keys Constraints
6.69.6
Check Constraints
6.69.7
Indexes pane
6.69.8
In-Memory pane
6.69.9
Storage pane
6.69.10
Column Sequences pane
6.69.11
Table Properties pane
6.69.12
LOB Parameters pane
6.69.13
Partitioning pane
6.69.14
Subpartition Templates pane
6.69.15
Partition Definitions pane
6.69.16
Index Organized Properties pane
6.69.17
External Table Properties pane
6.69.18
Comment pane
6.69.19
DDL pane
6.69.20
Hive Tables
6.69.20.1
Hive Tables: Partitions
6.69.20.2
Hive Tables: Buckets
6.69.20.3
Hive Tables: Skew
6.69.20.4
Hive Tables: Storage
6.69.20.5
Hive Tables: Table Properties
6.70
Storage Options
6.71
Create/Edit Tablespace
6.71.1
File Specifications tab
6.71.2
Properties tab
6.71.3
Default Parameters tab
6.71.4
DDL tab
6.72
Create Trigger
6.73
Create Type (User-Defined)
6.74
Create/Edit User
6.74.1
User tab
6.74.2
Granted Roles tab
6.74.3
System Privileges tab
6.74.4
Quotas tab
6.74.5
SQL tab
6.75
Create/Edit User Defined Report
6.76
Create/Edit User Defined Report Folder
6.77
Create/Edit View
6.77.1
SQL Query tab or pane
6.77.2
View Properties or Materialized View Properties pane
6.77.3
DDL tab or pane
6.77.4
Quick-Pick Objects pane
6.77.5
FROM Clause pane
6.77.6
SELECT Clause pane
6.77.7
WHERE Clause pane
6.77.8
GROUP BY Clause pane
6.77.9
HAVING Clause pane
6.77.10
ORDER BY Clause pane
6.78
Create Window
6.79
Create Window Group
6.80
Create XML Document from XML Schema
6.81
Create XML Schema
6.82
Custom Filters
6.83
Customize Toolbars
6.84
Data Pump Export
6.84.1
Source page
6.84.2
Tablespaces page
6.84.3
Schemas page
6.84.4
Tables page
6.84.5
Filter page
6.84.6
Table Data page
6.84.7
Options page
6.84.8
Output Files page
6.84.9
Job Schedule page
6.84.10
Summary page
6.85
Data Pump Import
6.85.1
Type page
6.85.2
Tablespaces page
6.85.3
Schemas page
6.85.4
Tables page
6.85.5
Filter page
6.85.6
Table Data page
6.85.7
Remapping page
6.85.8
Options page
6.85.9
Job Schedule page
6.85.10
Summary page
6.86
Database Copy
6.86.1
Source/Destination page
6.86.2
Object Types page
6.86.3
Select Schemas page
6.86.4
Select Tablespace page
6.86.5
Specify Objects page
6.86.6
Specify Data page
6.86.7
Summary page
6.87
Database Differences
6.87.1
Source/Destination page
6.87.2
Types to Diff page
6.87.3
Specify Objects page
6.87.4
Summary page
6.88
Database Export (Unload Database Objects and Data)
6.88.1
Source/Destination page
6.88.2
Types to Export page
6.88.3
Specify Objects page
6.88.4
Specify Data page
6.88.5
Export Summary page
6.89
DDL Panel for Creating or Editing an Object
6.90
Debugger - Attach to JPDA
6.91
Deploy or Import Application
6.92
Deploy Objects to Cloud
6.92.1
Cloud
6.92.2
Authorization
6.92.3
Transfer
6.92.4
Deploy DDL
6.92.5
Deploy Data
6.92.6
Unsupported Cart Object for Cloud Deployment
6.92.7
Other Errors (Invalid or Missing Entries)
6.93
Describe Object Window
6.94
Diff Objects
6.95
Drop Pluggable Database
6.96
Drop REST Services for Schema
6.97
Edit/View Value (Data or Table Column)
6.98
Enter Bind Values
6.99
Erase from Disk
6.100
Error Writing to Export File
6.101
Export Error
6.102
Export Data
6.103
Export Objects
6.104
Export: Unique Names Warning
6.105
External Locator Configuration
6.106
External Tools
6.107
Create/Edit External Tool
6.107.1
Program Options
6.107.2
Display
6.107.3
Integration
6.107.4
Availability
6.108
Choose Offline Options
6.109
Edit Font Location
6.110
Edit Header or Footer (PDF Formatting)
6.111
Edit Join
6.112
Feature Missing
6.113
Feature Required
6.114
File Processing
6.115
Filter
6.116
Filter Object Types
6.117
Filter Schemas
6.118
Filter Error
6.119
Find/Highlight
6.120
Git: Add
6.121
Git: Add All
6.122
Git: Add to .gitignore File
6.123
Git: Checkout Revision
6.124
Git: Clone from Git
6.125
Git: Commit
6.126
Git: Commit All
6.127
Git: Create Branch
6.128
Git: Create Tag
6.129
Git: Export Committed Changes
6.130
Git: Export Uncommitted Changes
6.131
Git: Fetch from Git
6.132
Git: Initialize Repository
6.133
Git: Merge
6.134
Git: Pull from Git
6.135
Git: Push to Git
6.136
Git: Revert
6.137
Insert Macro
6.138
Externally Modified Files
6.139
Find/Replace Text
6.140
Find Result
6.141
Format Properties (Advanced Formatting)
6.142
Generate Patch
6.143
Go to Bookmark
6.144
Go to Line Number
6.145
Go to Line Number: Error
6.146
History
6.147
Import Using Oracle Loader for Hadoop
6.148
Import Using Oracle SQL Connector for HDFS
6.149
Install/Run Oracle REST Data Services
6.149.1
ORDS File Locations
6.149.2
Database Connection
6.149.3
Select Tablespace
6.149.4
PL/SQL Gateway
6.149.5
APEX RESTful Services
6.149.6
Run Standalone Mode
6.149.7
ORDS Users
6.149.8
Summary
6.150
Install SQL Translator
6.150.1
Installing a Translator and Creating a Profile: Usage Notes
6.151
Invalid Database Version
6.152
Load Extension
6.153
Load Keyboard Scheme
6.154
LOB Descriptors
6.155
Maintain Spatial Metadata
6.156
Manage Columns
6.157
Manage Connections (REST)
6.158
Manage Features and Updates
6.159
Map Connection
6.160
Merge Migration Projects
6.161
Modify Pluggable State
6.162
Modify Value
6.163
Data Move Details
6.164
New/Edit Change Set
6.165
New Procedure (Refactoring)
6.166
New/Edit Local or Remote Port Forward
6.167
New/Edit SSH Connection
6.168
No Lock
6.169
No Object Found
6.170
No Object Selected
6.171
Object Preferences
6.172
Offline Generation Error - Destination Directory
6.173
Open File
6.174
Oracle-Only Report
6.175
Paste
6.176
Perforce: Add Files to Perforce
6.177
Perforce: Connection
6.178
Perforce: Create Changelist
6.179
Perforce: Delete Files
6.180
Perforce: Login
6.181
Perforce: Open Files for Edit
6.182
Perforce: Revert Files
6.183
Perforce: Sync Files
6.184
Perforce: Submit Changelist
6.185
Plug In Pluggable Database
6.186
Print Preview
6.187
Privilege Warning for Migration
6.188
Recent Files
6.189
Delete or Truncate Repository
6.189.1
Error Truncating Repository
6.190
Rename Local Variable
6.191
Rename Tab
6.192
Rename Procedure
6.193
REST Data Services Connection
6.194
REST Data Services Connection: Authentication Failed
6.195
REST Data Services Connection: Remove Connection
6.196
RESTful Services Wizard (Auto-Enable REST Access)
6.196.1
Specify Details
6.196.2
RESTful Summary
6.197
RESTful Services Wizard and Object Dialog Boxes
6.197.1
Resource Module
6.197.2
Resource Template
6.197.3
Resource Handler
6.197.3.1
Resource Handler Editing Pane
6.197.4
RESTful Summary
6.198
RESTful Services Connection
6.199
RESTful Services Privilege
6.200
Select Current Repository
6.201
Cannot Capture Table
6.202
Report Panel
6.203
Reset Expired Password (Enter New Password)
6.204
Revision Lister
6.205
Run/Debug/Profile PL/SQL
6.206
Create/Edit Breakpoint
6.206.1
Definition tab
6.206.2
Conditions tab
6.206.3
Actions tab
6.207
Save/Save As, or Select File
6.208
Save or Open Cart Tool Configuration
6.209
Save Files
6.210
Unable to Save Files
6.211
Save Style Settings
6.212
Schema Differences Source or Destination Error
6.213
Script Execution Failed
6.214
Script Generation Complete
6.215
Set Data Mapping
6.216
Add/Edit Rule
6.217
Set Encoding
6.218
Set Pause Continue
6.219
Shared Wizard Pages
6.219.1
Types
6.219.2
Specify Objects
6.219.3
Data
6.219.4
Summary
6.220
Sign In (checking for updates)
6.221
Single Record View
6.222
Save Snippet (User-Defined)
6.223
Edit Snippets (User-Defined)
6.224
Show SQL
6.225
Start Date, End Date, Repeat Interval, Comments (Scheduler)
6.226
Subversion: Add Property
6.227
Subversion: Add to Source Control
6.228
Subversion: Apply Patch
6.229
Subversion: Branch/Tag
6.230
Subversion: Check Out from Subversion
6.231
Subversion: Commit Resources
6.232
Subversion: Commit Working Copy
6.233
Subversion: Confirm Checkout
6.234
Subversion: Create Remote Directory
6.235
Subversion: Create Subversion Repository
6.236
Subversion: Create/Edit Subversion Connection
6.237
Subversion: Delete Resources
6.238
Subversion: Edit Configuration File
6.239
Subversion: Export Files
6.240
Subversion: Export Subversion Connections
6.241
Subversion: Ignore
6.242
Subversion: Import Subversion Connections
6.243
Subversion: Import to Subversion
6.243.1
Destination
6.243.2
Source
6.243.3
Filters
6.243.4
Options
6.243.5
Summary
6.244
Subversion: Lock Resources
6.245
Subversion: Merge
6.246
Subversion: Pending Changes
6.247
Subversion: Properties
6.248
Subversion: Remove from Subversion
6.249
Subversion: Repository Browser
6.250
Subversion: Revert Local Changes
6.251
Subversion: Switch
6.252
Subversion: Unlock Resources
6.253
Subversion: Update Resources
6.254
Subversion: Update Working Copy
6.255
Subversion: Versioning Properties
6.256
Third-Party Database Objects
6.257
Unable to Connect
6.258
Unable to Open File
6.259
Uninstall Oracle REST Data Services
6.260
Unit Testing: Action Required
6.261
Unit Testing: Add Category
6.262
Unit Testing: Add Data Type
6.263
Unit Testing: Add Item to Library
6.264
Unit Testing: Add Test Implementation
6.265
Unit Testing: Add Test Suite
6.266
Unit Testing: Add Tests or Suites to a Suite
6.267
Unit Testing: Copy or Rename Unit Test
6.268
Unit Testing: Create Unit Test
6.268.1
Select Operation
6.268.2
Specify Test Name
6.268.3
Specify Startup
6.268.4
Specify Parameters
6.268.5
Specify Validations
6.268.6
Specify Teardown
6.268.7
Summary
6.269
Unit Testing: Manage Users
6.270
Unit Testing: Rename Test Implementation
6.271
Unit Testing: Result of Operation
6.272
Unit Testing: Synchronize Unit Test
6.273
Unplug Pluggable Database
6.274
Unsupported Database Version
6.275
Validate Geometry
6.276
View Whole Value
6.277
Windows
6.278
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.