Table of Contents
- List of Figures
- Title and Copyright Information
-
Preface
- Audience
- Documentation Accessibility
- Product Accessibility
- Related Documents
- Conventions
-
Third-Party License Information
- ActiveQueryBuilder 1.9.0.1154
- Antlr 3.1.3
- Apache Commons Logging 1.2
- Apache Mina SSHD 2.4.0
- Apache POI 4.1.2
- HttpComponents Http Client 4.5.12
- HttpCore 4.4.13
- iText OEM Desktop 5.5.13.1
- jackson-annotations 2.10.3
- jackson-core 2.10.3
- jackson-jr-objects 2.10.3
- JGoodies Looks 1.3.1
- jGraphx 4.1.1
- jLine 2.14.6
- JXLayer 4.0
- Kafka 2.4
- Launch4j 3.12
- Liquibase 3.8.9
- Log4j 2.13.1
- StringTemplate 3.1, 4.3
- SVNKit 1.0.0
- 1 Changes in Release 20.2 for Oracle SQL Developer User's Guide
-
2
SQL Developer Concepts and Usage
- 2.1 About SQL Developer
- 2.2 Installing and Getting Started with SQL Developer
- 2.3 SQL Developer User Interface
-
2.4
Database Objects
- 2.4.1 Applications (Application Express 3.0.1 and Later)
- 2.4.2 Cache Groups (Oracle TimesTen In-Memory Database)
- 2.4.3 Chains
- 2.4.4 Credentials
- 2.4.5 Database Destinations
- 2.4.6 Database Links (Public and Private)
- 2.4.7 Destination Groups
- 2.4.8 Directories
- 2.4.9 Editions
- 2.4.10 File Watchers
- 2.4.11 Functions
- 2.4.12 Indexes
- 2.4.13 Java Sources
- 2.4.14 Jobs
- 2.4.15 Job Classes
- 2.4.16 Operators
- 2.4.17 Materialized Views
- 2.4.18 Materialized View Logs
- 2.4.19 Multitenant Container Database (CDB)
- 2.4.20 Packages
- 2.4.21 Procedures
- 2.4.22 Programs
- 2.4.23 Queues
- 2.4.24 Queue Tables
- 2.4.25 Recycle Bin
- 2.4.26 Replication Schemes (Oracle TimesTen In-Memory Database)
- 2.4.27 Schedules
- 2.4.28 Sequences
- 2.4.29 Synonyms (Public and Private)
- 2.4.30 Tables
- 2.4.31 Triggers
- 2.4.32 Types
- 2.4.33 Users (Other Users)
- 2.4.34 Views
- 2.4.35 Window Groups
- 2.4.36 Windows
- 2.4.37 XML DB Repository
- 2.4.38 XML Schemas
- 2.4.39 Captured and Converted Database Objects (for Migration)
- 2.5 Database Connections
- 2.6 Entering and Modifying Data
- 2.7 Running and Debugging Functions and Procedures
-
2.8
Using the SQL Worksheet
- 2.8.1 SQL*Plus Statements Supported in SQL Worksheet
- 2.8.2 Script Runner
- 2.8.3 Execution Plan
- 2.8.4 Autotrace Pane
- 2.8.5 DBMS Output Pane
- 2.8.6 OWA Output Pane
- 2.8.7 SQL History
- 2.8.8 Query Builder
- 2.8.9 Command-Line Interface for SQL Formatting
- 2.8.10 SQL Worksheet "Hints" for Formatting Output
- 2.8.11 Gauges: In the SQL Worksheet and User-Defined Reports
- 2.8.12 Entering OLAP DML Statements in the SQL Worksheet
- 2.9 Using Snippets to Insert Code Fragments
- 2.10 Finding Database Objects
- 2.11 Using Recent Objects
- 2.12 Using Versioning
-
2.13
Using DBA Features in SQL Developer
- 2.13.1 Container Database (CDB)
- 2.13.2 Database Configuration
- 2.13.3 Database Status
- 2.13.4 Data Guard
- 2.13.5 Data Pump
- 2.13.6 Oracle Sharding
- 2.13.7 Performance
- 2.13.8 RMAN Backup/Recovery
- 2.13.9 Resource Manager
- 2.13.10 SQL Translator FrameWork
- 2.13.11 Scheduler
- 2.13.12 Security
- 2.13.13 Storage
- 2.13.14 Tuning
- 2.14 Scheduling Jobs Using SQL Developer
- 2.15 Using the Cart
- 2.16 Spatial Support in SQL Developer
- 2.17 Change Manager Support in SQL Developer
- 2.18 Apache Hadoop Support in SQL Developer using Oracle Big Data Connectors and Copy to Hadoop
-
2.19
Support for Oracle SQL Access to
Kafka
- 2.19.1 Overview
- 2.19.2 Prerequisites
- 2.19.3 Installation and Configuration
-
2.19.4
Get Started
- 2.19.4.1 Register a Kafka Cluster
- 2.19.4.2 Supported Kafka Record Types
- 2.19.4.3 Create Views to Access CSV Data in a Kafka Topic
- 2.19.4.4 Create Views to Access JSON Data in a Kafka Topic
- 2.19.4.5 Query Kafka Data as Continuous Streams
- 2.19.4.6 Explore Kafka Data from a Specific Offset
- 2.19.4.7 Explore Kafka Data from a Specific Timestamp
- 2.19.4.8 Customize Oracle SQL Access to Kafka Views
- 2.19.4.9 Reconfigure Existing Kafka Views When New Partitions are Added to an Existing Topic
- 2.19.4.10 Load Kafka Data into Tables Stored in Oracle Database
- 2.19.4.11 Load Kafka Data into Temporary Tables
- 2.19.5 Reference Information
-
2.20
SQL Developer Reports
- 2.20.1 Bind Variables for Reports
- 2.20.2 About Your Database reports
- 2.20.3 All Objects reports
- 2.20.4 Application Express reports
- 2.20.5 ASH and AWR reports
- 2.20.6 Charts reports
- 2.20.7 Database Administration reports
- 2.20.8 Data Dictionary reports
- 2.20.9 Scheduler reports
- 2.20.10 PL/SQL reports
- 2.20.11 Security reports
- 2.20.12 Streams reports
- 2.20.13 Table reports
- 2.20.14 XML reports
- 2.20.15 Data Modeler reports
- 2.20.16 User Defined reports
-
2.21
SQL Developer Preferences
- 2.21.1 Environment
- 2.21.2 Change Management Parameters
- 2.21.3 Code Editor
- 2.21.4 Compare and Merge
- 2.21.5 Database
- 2.21.6 Debugger
- 2.21.7 External Editor
- 2.21.8 File Types
- 2.21.9 Migration
- 2.21.10 Mouse Actions
- 2.21.11 Oracle Swift Object Storage
- 2.21.12 Shortcut Keys (Accelerator Keys)
- 2.21.13 SSH (Secure Shell)
- 2.21.14 Unit Test Parameters
- 2.21.15 Usage Reporting
- 2.21.16 Versioning
- 2.21.17 Web Browser and Proxy
- 2.21.18 XML Schemas
- 2.22 Location of User-Related Information
- 2.23 Java Development Kit (JDK) Location
- 2.24 Command-Line Interface for SQL Developer
- 2.25 Data Modeler in SQL Developer
- 2.26 Oracle TimesTen In-Memory Database Support
- 2.27 SQL Developer Support for RDF Data
- 2.28 Using the Help
-
2.29
SQL Developer Usage Suggestions
- 2.29.1 SQL History Shortcuts
- 2.29.2 Unshared Worksheets
- 2.29.3 SQL Worksheet Bookmarks
- 2.29.4 Oracle Data Miner
- 2.29.5 Formatted Display of SQL Trace (.trc) Files
- 2.29.6 Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
- 2.29.7 Folders for Organizing Connections
- 2.29.8 Third-Party Databases and SQL Developer
- 2.29.9 Debugger Ports and Firewalls
- 2.29.10 Viewing Multiple Tables
- 2.29.11 Customizing SQL Developer Appearance
- 2.29.12 Maximizing Tab Panes
- 2.29.13 Default Path for Running Scripts
- 2.29.14 Shutting Down and Restarting the Database
- 2.29.15 Feature Requests
- 2.29.16 Discussion Forums
- 2.29.17 Help Text Font Size
- 2.29.18 Procedure and Function Signatures
- 2.29.19 Type-Ahead in Navigators
- 2.29.20 Extended Paste
- 2.29.21 Closing Tabbed Windows Using the Mouse Wheel
- 2.29.22 Go to Last Edit Location
- 2.29.23 Closing Tabbed Windows Using the Context Menu
- 2.29.24 List of All Open Windows
- 2.29.25 Go to Subprogram Implementation from Package Window
- 2.29.26 Select Multiple Table or Column Names in Completion Insight
- 2.29.27 Startup Time and Automatic Check for Updates
- 2.30 For More Information About SQL Developer
-
3
SQL Developer: Migrating Third-Party Databases
- 3.1 Migration: Basic Options and Steps
-
3.2
Migration: Background Information and Guidelines
- 3.2.1 Overview of Migration
- 3.2.2 Preparing a Migration Plan
- 3.2.3 Before You Start Migrating: General Information
- 3.2.4 Before You Start Migrating: Source-Specific Information
- 3.2.5 Capturing the Source Database
- 3.2.6 Creating and Customizing the Converted Model
- 3.2.7 Generating the DDL for the Oracle Schema Objects
- 3.2.8 Migrating the Data
- 3.2.9 Making Queries Case Insensitive
- 3.2.10 Testing the Oracle Database
- 3.2.11 Deploying the Oracle Database
- 3.3 SQL Developer User Interface for Migration
- 3.4 Command-Line Interface for Migration
-
4
SQL Developer: Oracle REST Data Services Support
- 4.1 Installing Oracle REST Data Services
- 4.2 Oracle REST Data Services Administration
- 4.3 Automatically Enabling REST Access to a Schema, Table, or View (AutoREST)
- 4.4 REST Development
-
5
SQL Developer: Unit Testing
- 5.1 Overview of Unit Testing
- 5.2 SQL Developer User Interface for Unit Testing
- 5.3 Unit Test Repository
- 5.4 Editing and Running a Unit Test
- 5.5 Using a Dynamic Value Query to Create a Unit Test
- 5.6 Using Lookups to Simplify Unit Test Creation
- 5.7 Using Variable Substitution in Validation Actions
- 5.8 Unit Test Library
- 5.9 Unit Test Reports
- 5.10 Exporting and Importing Unit Test Objects
- 5.11 Command-Line Interface for Unit Testing
- 5.12 Unit Testing Best Practices
- 5.13 Example of Unit Testing (Tutorial)
-
6
SQL Developer Tutorial: Creating Objects for a Small Database
- 6.1 Create a Table (BOOKS)
- 6.2 Create a Table (PATRONS)
- 6.3 Create a Table (TRANSACTIONS)
- 6.4 Create a Sequence
- 6.5 Insert Data into the Tables
- 6.6 Create a View
- 6.7 Create a PL/SQL Procedure
- 6.8 Debug a PL/SQL Procedure
- 6.9 Use the SQL Worksheet for Queries
- 6.10 Script for Creating and Using the Library Tutorial Objects
-
7
SQL Developer Dialog Boxes and Wizards
- 7.1 Add Extension
- 7.2 Add Schema Error
- 7.3 Application Migration
- 7.4 Associate Repository
- 7.5 Cart Error (Objects Not Available)
- 7.6 Change Type
- 7.7 Check for Updates
- 7.8 Choose Configuration File Option
- 7.9 Choose Directory
- 7.10 Clone PDB to Oracle Cloud
- 7.11 Clone Pluggable Database
- 7.12 Cloud Migrations Wizard
- 7.13 Color Palette and Custom Colors
- 7.14 Configure Extension
- 7.15 Configure File Type Associations
- 7.16 Configure OSS for Oracle Call Infrastructure Classic
- 7.17 Copy Columns
- 7.18 Copy Objects
- 7.19 Copy to Hadoop / Append to Hadoop Table
- 7.20 Copy to Oracle
- 7.21 Component Palette
- 7.22 Component Palette: Configure Component Palette
- 7.23 Component Palette: Create Palette Page
- 7.24 Component Palette: New/Edit Code Snippet
- 7.25 Component Palette: New Section/Rename Section
- 7.26 Confirm Drop Application
- 7.27 Confirm Running SQL
- 7.28 Connection Has Uncommitted Changes
- 7.29 Create New Object
- 7.30 Create/Edit Chain
- 7.31 Create/Edit Credential
- 7.32 Create/Edit/Select Database Connection
- 7.33 New/Edit Cloud Connection
- 7.34 New/Edit NoSQL Connection
- 7.35 Rename Model (Migration)
- 7.36 Delete Confirmation
- 7.37 Delete Confirmation (Migration)
- 7.38 Rename Database Item (Migration)
- 7.39 Select Connection
- 7.40 Connection Information
- 7.41 No Connection Found
- 7.42 Connection Rename Error
- 7.43 New Folder (Connections)
- 7.44 Continue After Pause
- 7.45 Select Library
- 7.46 Create Library
- 7.47 CVS: Check Out from CVS
- 7.48 CVS: Create/Edit CVS Connection
- 7.49 CVS: Import to CVS
- 7.50 CVS: Log In to CVS
- 7.51 Data Import Wizard
- 7.52 Export/Import Connections
- 7.53 Create/Edit Database Destination
- 7.54 Create/Edit Destination Group (Database or External)
- 7.55 Create/Edit Database Link
- 7.56 Create/Edit Index
- 7.57 Create File Watcher
- 7.58 Create Filter
- 7.59 Create Function or Procedure
- 7.60 Create/Edit Job
- 7.61 Create/Edit Job Class
- 7.62 Create/Edit Materialized View Log
- 7.63 Create PL/SQL Package
- 7.64 Create Pluggable Database
- 7.65 Create/Edit Program
- 7.66 Create/Edit Role
- 7.67 Create/Edit Schedule
- 7.68 Create/Edit Sequence
- 7.69 Create SQL File
- 7.70 Create/Edit Synonym
- 7.71 Create Table (quick creation)
-
7.72
Create/Edit Table (with advanced options)
- 7.72.1 Columns pane
- 7.72.2 Constraints
- 7.72.3 Primary Key Constraint
- 7.72.4 Unique Constraints
- 7.72.5 Foreign Keys Constraints
- 7.72.6 Check Constraints
- 7.72.7 Indexes pane
- 7.72.8 In-Memory pane
- 7.72.9 Storage pane
- 7.72.10 Column Sequences pane
- 7.72.11 Table Properties pane
- 7.72.12 LOB Parameters pane
- 7.72.13 Partitioning pane
- 7.72.14 Subpartition Templates pane
- 7.72.15 Partition Definitions pane
- 7.72.16 Partition Sets pane
- 7.72.17 Index Organized Properties pane
- 7.72.18 External Table Properties pane
- 7.72.19 Comment pane
- 7.72.20 DDL pane
- 7.72.21 Hive Tables
- 7.73 Storage Options
- 7.74 Create/Edit Tablespace
- 7.75 Create Trigger
- 7.76 Create Type (User-Defined)
- 7.77 Create/Edit User
- 7.78 Create/Edit User Defined Report
- 7.79 Create/Edit User Defined Report Folder
-
7.80
Create/Edit View
- 7.80.1 SQL Query tab or pane
- 7.80.2 View Properties or Materialized View Properties pane
- 7.80.3 DDL tab or pane
- 7.80.4 Quick-Pick Objects pane
- 7.80.5 FROM Clause pane
- 7.80.6 SELECT Clause pane
- 7.80.7 WHERE Clause pane
- 7.80.8 GROUP BY Clause pane
- 7.80.9 HAVING Clause pane
- 7.80.10 ORDER BY Clause pane
- 7.81 Create Window
- 7.82 Create Window Group
- 7.83 Create XML Document from XML Schema
- 7.84 Create XML Schema
- 7.85 Custom Filters
- 7.86 Customize Toolbars
- 7.87 Data Pump Export
- 7.88 Data Pump Import
- 7.89 Database Copy
- 7.90 Database Differences
- 7.91 Database Export (Unload Database Objects and Data)
- 7.92 DDL Panel for Creating or Editing an Object
- 7.93 Debugger - Attach to JPDA
- 7.94 Deploy or Import Application
- 7.95 Deploy Objects to Cloud
- 7.96 Describe Object Window
- 7.97 Diff Objects
- 7.98 Drop Pluggable Database
- 7.99 Drop REST Services for Schema
- 7.100 Edit/View Value (Data or Table Column)
- 7.101 Enter Bind Values
- 7.102 Erase from Disk
- 7.103 Error Writing to Export File
- 7.104 Export Error
- 7.105 Export Data
- 7.106 Export Objects
- 7.107 Export Resource Module, Privilege, and Role
- 7.108 Export: Unique Names Warning
- 7.109 External Locator Configuration
- 7.110 External Tools
- 7.111 Create/Edit External Tool
- 7.112 Choose Offline Options
- 7.113 Edit Font Location
- 7.114 Edit Header or Footer (PDF Formatting)
- 7.115 Edit Join
- 7.116 Extract Variable/Function/CTE for Refactoring
- 7.117 Feature Missing
- 7.118 Feature Required
- 7.119 File Processing
- 7.120 Filter
- 7.121 Filter Object Types
- 7.122 Filter Schemas
- 7.123 Filter Error
- 7.124 Find/Highlight
- 7.125 Git: Add
- 7.126 Git: Add All
- 7.127 Git: Add to .gitignore File
- 7.128 Git: Checkout Revision
- 7.129 Git: Clone from Git
- 7.130 Git: Commit
- 7.131 Git: Commit All
- 7.132 Git: Create Branch
- 7.133 Git: Create Tag
- 7.134 Git: Export Committed Changes
- 7.135 Git: Export Uncommitted Changes
- 7.136 Git: Fetch from Git
- 7.137 Git: Initialize Repository
- 7.138 Git: Merge
- 7.139 Git: Pull from Git
- 7.140 Git: Push to Git
- 7.141 Git: Revert
- 7.142 Insert Macro
- 7.143 Externally Modified Files
- 7.144 Find/Replace Text
- 7.145 Find Result
- 7.146 Format Properties (Advanced Formatting)
- 7.147 Generate Patch
- 7.148 Go to Bookmark
- 7.149 Go to Line Number
- 7.150 Go to Line Number: Error
- 7.151 History
- 7.152 Import Using Oracle Loader for Hadoop
- 7.153 Import Using Oracle SQL Connector for HDFS
- 7.154 Install/Run Oracle REST Data Services
- 7.155 Install SQL Translator
- 7.156 Invalid Database Version
- 7.157 Load Extension
- 7.158 Load Keyboard Scheme
- 7.159 LOB Descriptors
- 7.160 Maintain Spatial Metadata
- 7.161 Manage Columns
- 7.162 Manage Connections (REST)
- 7.163 Manage Features and Updates
- 7.164 Map Connection
- 7.165 Merge Migration Projects
- 7.166 Modify Pluggable State
- 7.167 Modify Value
- 7.168 Data Move Details
- 7.169 New/Edit Change Set
- 7.170 New Procedure (Refactoring)
- 7.171 New/Edit Local or Remote Port Forward
- 7.172 Edit SSH Connection
- 7.173 No Lock
- 7.174 No Object Found
- 7.175 No Object Selected
- 7.176 Object Preferences
- 7.177 Offline Generation Error - Destination Directory
- 7.178 Open File
- 7.179 Oracle-Only Report
- 7.180 Paste
- 7.181 Perforce: Add Files to Perforce
- 7.182 Perforce: Connection
- 7.183 Perforce: Create Changelist
- 7.184 Perforce: Delete Files
- 7.185 Perforce: Login
- 7.186 Perforce: Open Files for Edit
- 7.187 Perforce: Revert Files
- 7.188 Perforce: Sync Files
- 7.189 Perforce: Submit Changelist
- 7.190 Plug In Pluggable Database
- 7.191 Print Preview
- 7.192 Privilege Warning for Migration
- 7.193 Publish to REST
- 7.194 Recent Files
- 7.195 Delete or Truncate Repository
- 7.196 Rename Local Variable
- 7.197 Rename Tab
- 7.198 Rename Procedure
- 7.199 Repair (Validate) Oracle REST Data Services
- 7.200 REST Data Services Connection
- 7.201 REST Data Services Connection: Authentication Failed
- 7.202 REST Data Services Connection: Remove Connection
- 7.203 RESTful Services Wizard (Auto-Enable REST Access)
- 7.204 RESTful Services Wizard and Object Dialog Boxes
- 7.205 RESTful Services Connection
- 7.206 RESTful Services Privilege
- 7.207 RESTful Services Roles
- 7.208 Select Current Repository
- 7.209 Cannot Capture Table
- 7.210 Report Panel
- 7.211 Reset Expired Password (Enter New Password)
- 7.212 Revision Lister
- 7.213 Run/Debug/Profile PL/SQL
- 7.214 Create/Edit Breakpoint
- 7.215 Save/Save As, or Select File
- 7.216 Save or Open Cart Tool Configuration
- 7.217 Save Files
- 7.218 Unable to Save Files
- 7.219 Save Style Settings
- 7.220 Schema Differences Source or Destination Error
- 7.221 Script Execution Failed
- 7.222 Script Generation Complete
- 7.223 Set Data Mapping
- 7.224 Add/Edit Rule
- 7.225 Set Encoding
- 7.226 Set Pause Continue
- 7.227 Shared Wizard Pages
- 7.228 Sign In (checking for updates)
- 7.229 Single Record View
- 7.230 Save Snippet (User-Defined)
- 7.231 Edit Snippets (User-Defined)
- 7.232 Show SQL
- 7.233 Start Date, End Date, Repeat Interval, Comments (Scheduler)
- 7.234 Subversion: Add Property
- 7.235 Subversion: Add to Source Control
- 7.236 Subversion: Apply Patch
- 7.237 Subversion: Branch/Tag
- 7.238 Subversion: Check Out from Subversion
- 7.239 Subversion: Commit Resources
- 7.240 Subversion: Commit Working Copy
- 7.241 Subversion: Confirm Checkout
- 7.242 Subversion: Create Remote Directory
- 7.243 Subversion: Create Subversion Repository
- 7.244 Subversion: Create/Edit Subversion Connection
- 7.245 Subversion: Delete Resources
- 7.246 Subversion: Edit Configuration File
- 7.247 Subversion: Export Files
- 7.248 Subversion: Export Subversion Connections
- 7.249 Subversion: Ignore
- 7.250 Subversion: Import Subversion Connections
- 7.251 Subversion: Import to Subversion
- 7.252 Subversion: Lock Resources
- 7.253 Subversion: Merge
- 7.254 Subversion: Pending Changes
- 7.255 Subversion: Properties
- 7.256 Subversion: Remove from Subversion
- 7.257 Subversion: Repository Browser
- 7.258 Subversion: Revert Local Changes
- 7.259 Subversion: Switch
- 7.260 Subversion: Unlock Resources
- 7.261 Subversion: Update Resources
- 7.262 Subversion: Update Working Copy
- 7.263 Subversion: Versioning Properties
- 7.264 Third-Party Database Objects
- 7.265 Unable to Connect
- 7.266 Unable to Open File
- 7.267 Uninstall Oracle REST Data Services
- 7.268 Unit Testing: Action Required
- 7.269 Unit Testing: Add Category
- 7.270 Unit Testing: Add Data Type
- 7.271 Unit Testing: Add Item to Library
- 7.272 Unit Testing: Add Test Implementation
- 7.273 Unit Testing: Add Test Suite
- 7.274 Unit Testing: Add Tests or Suites to a Suite
- 7.275 Unit Testing: Copy or Rename Unit Test
- 7.276 Unit Testing: Create Unit Test
- 7.277 Unit Testing: Manage Users
- 7.278 Unit Testing: Rename Test Implementation
- 7.279 Unit Testing: Result of Operation
- 7.280 Unit Testing: Synchronize Unit Test
- 7.281 Unplug Pluggable Database
- 7.282 Unsupported Database Version
- 7.283 Validate Geometry
- 7.284 View Whole Value
- 7.285 Windows
- 7.286 XMLType Column Properties