Table of Contents
- List of Figures
- Title and Copyright Information
-
Preface
- Audience
- Documentation Accessibility
- Product Accessibility
- Related Documents
- Conventions
-
Third-Party License Information
- Antlr 3.1.3
- Apache Mina SSHD 2.9.2
- Apache Mina SSHD-contrib 2.13.2
- Apache Mina SSHD-core 2.11.0
- Apache Mina SSHD-putty 2.13.2
- Apache Mina SSHD-scp 2.13.2
- Apache Mina SSHD-sftp 2.13.2
- Apache POI 5.2.5
- ASM 9.7
- Google Guava 33.2.1-jre
- httpclient 5.3.1
- httpcore5 5.2.4, httpcore5-h2 5.2.4
- jackson-annotations 2.17.2
- jackson-core 2.17.2
- jackson-jr-objects 2.17.2
- jGraphx 4.2.0
- poi-ooxml 5.2.5
- poi-ooxml-lite 5.2.5
- StringTemplate 3.1-1, 4.3.4
- 1 Changes in Release 24.3 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 and SQLcl Commands 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
Support for Oracle SQL Access to
Kafka
- 2.18.1 Overview
- 2.18.2 Prerequisites
- 2.18.3 Installation and Configuration
-
2.18.4
Get Started
- 2.18.4.1 Register a Kafka Cluster
- 2.18.4.2 Supported Kafka Record Types
- 2.18.4.3 Create Views to Access CSV Data in a Kafka Topic
- 2.18.4.4 Create Views to Access JSON Data in a Kafka Topic
- 2.18.4.5 Query Kafka Data as Continuous Streams
- 2.18.4.6 Explore Kafka Data from a Specific Offset
- 2.18.4.7 Explore Kafka Data from a Specific Timestamp
- 2.18.4.8 Customize Oracle SQL Access to Kafka Views
- 2.18.4.9 Reconfigure Existing Kafka Views When New Partitions are Added to an Existing Topic
- 2.18.4.10 Load Kafka Data into Tables Stored in Oracle Database
- 2.18.4.11 Load Kafka Data into Temporary Tables
- 2.18.5 Reference Information
-
2.19
SQL Developer Reports
- 2.19.1 Bind Variables for Reports
- 2.19.2 About Your Database reports
- 2.19.3 All Objects reports
- 2.19.4 Application Express reports
- 2.19.5 ASH and AWR reports
- 2.19.6 Charts reports
- 2.19.7 Database Administration reports
- 2.19.8 Data Dictionary reports
- 2.19.9 Scheduler reports
- 2.19.10 PL/SQL reports
- 2.19.11 Security reports
- 2.19.12 Streams reports
- 2.19.13 Table reports
- 2.19.14 XML reports
- 2.19.15 Data Modeler reports
- 2.19.16 User Defined reports
-
2.20
SQL Developer Preferences
- 2.20.1 Environment
- 2.20.2 Change Management Parameters
- 2.20.3 Code Editor
- 2.20.4 Compare and Merge
- 2.20.5 Database
- 2.20.6 Debugger
- 2.20.7 External Editor
- 2.20.8 File Types
- 2.20.9 Migration
- 2.20.10 Mouse Actions
- 2.20.11 Oracle Swift Object Storage
- 2.20.12 Shortcut Keys (Accelerator Keys)
- 2.20.13 SSH (Secure Shell)
- 2.20.14 Usage Reporting
- 2.20.15 Versioning
- 2.20.16 Web Browser and Proxy
- 2.20.17 XML Schemas
- 2.21 Location of User-Related Information
- 2.22 Java Development Kit (JDK) Location
- 2.23 Command-Line Interface for SQL Developer
- 2.24 Data Modeler in SQL Developer
- 2.25 Oracle TimesTen In-Memory Database Support
- 2.26 SQL Developer Support for RDF Data
- 2.27 Support for Property Graph
- 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
-
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 Application Migration
- 6.4 Associate Repository
- 6.5 Cart Error (Objects Not Available)
- 6.6 Change Type
- 6.7 Check for Updates
- 6.8 Choose Configuration File Option
- 6.9 Choose Directory
- 6.10 Clone PDB to Oracle Cloud
- 6.11 Clone Pluggable Database
- 6.12 Cloud Migrations Wizard
- 6.13 Color Palette and Custom Colors
- 6.14 Configure Extension
- 6.15 Configure File Type Associations
- 6.16 Configure OSS for Oracle Call Infrastructure Classic
- 6.17 Copy Columns
- 6.18 Copy Objects
- 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.32 New/Edit Cloud Connection
- 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
- 6.51 Export/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.56 Create File Watcher
- 6.57 Create Filter
- 6.58 Create Function or Procedure
- 6.59 Create/Edit Job
- 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 Partition Sets pane
- 6.71.17 Index Organized Properties pane
- 6.71.18 External Table Properties pane
- 6.71.19 Comment pane
- 6.71.20 DDL pane
- 6.71.21 Hive Tables
- 6.72 Storage Options
- 6.73 Create/Edit Tablespace
- 6.74 Create Trigger
- 6.75 Create Type (User-Defined)
- 6.76 Create/Edit User
- 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.87 Data Pump Import
- 6.88 Database Copy
- 6.89 Database Differences
- 6.90 Database Export (Unload Database Objects and Data)
- 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.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.111 Choose Offline Options
- 6.112 Edit Font Location
- 6.113 Edit Header or Footer (PDF Formatting)
- 6.114 Edit Join
- 6.115 Extract Variable/Function/CTE for Refactoring
- 6.116 Feature Missing
- 6.117 Feature Required
- 6.118 File Processing
- 6.119 Filter
- 6.120 Filter Object Types
- 6.121 Filter Schemas
- 6.122 Filter Error
- 6.123 Find/Highlight
- 6.124 Git: Add
- 6.125 Git: Add All
- 6.126 Git: Add to .gitignore File
- 6.127 Git: Checkout Revision
- 6.128 Git: Clone from Git
- 6.129 Git: Commit
- 6.130 Git: Commit All
- 6.131 Git: Create Branch
- 6.132 Git: Create Tag
- 6.133 Git: Export Committed Changes
- 6.134 Git: Export Uncommitted Changes
- 6.135 Git: Fetch from Git
- 6.136 Git: Initialize Repository
- 6.137 Git: Merge
- 6.138 Git: Pull from Git
- 6.139 Git: Push to Git
- 6.140 Git: Revert
- 6.141 Insert Macro
- 6.142 Externally Modified Files
- 6.143 Find/Replace Text
- 6.144 Find Result
- 6.145 Format Properties (Advanced Formatting)
- 6.146 Generate Patch
- 6.147 Go to Bookmark
- 6.148 Go to Line Number
- 6.149 Go to Line Number: Error
- 6.150 History
- 6.151 Install/Run Oracle REST Data Services
- 6.152 Install SQL Translator
- 6.153 Invalid Database Version
- 6.154 Load Extension
- 6.155 Load Keyboard Scheme
- 6.156 LOB Descriptors
- 6.157 Maintain Spatial Metadata
- 6.158 Manage Columns
- 6.159 Manage Connections (REST)
- 6.160 Manage Features and Updates
- 6.161 Map Connection
- 6.162 Merge Migration Projects
- 6.163 Modify Pluggable State
- 6.164 Modify Value
- 6.165 Data Move Details
- 6.166 New/Edit Change Set
- 6.167 New Procedure (Refactoring)
- 6.168 New/Edit Local or Remote Port Forward
- 6.169 Edit SSH Connection
- 6.170 No Lock
- 6.171 No Object Found
- 6.172 No Object Selected
- 6.173 Object Preferences
- 6.174 Offline Generation Error - Destination Directory
- 6.175 Open File
- 6.176 Oracle-Only Report
- 6.177 Paste
- 6.178 Perforce: Add Files to Perforce
- 6.179 Perforce: Connection
- 6.180 Perforce: Create Changelist
- 6.181 Perforce: Delete Files
- 6.182 Perforce: Login
- 6.183 Perforce: Open Files for Edit
- 6.184 Perforce: Revert Files
- 6.185 Perforce: Sync Files
- 6.186 Perforce: Submit Changelist
- 6.187 Plug In Pluggable Database
- 6.188 Print Preview
- 6.189 Privilege Warning for Migration
- 6.190 Publish to REST
- 6.191 Recent Files
- 6.192 Delete or Truncate Repository
- 6.193 Rename Local Variable
- 6.194 Rename Tab
- 6.195 Rename Procedure
- 6.196 Repair (Validate) Oracle REST Data Services
- 6.197 RESTful Services Wizard (Auto-Enable REST Access)
- 6.198 RESTful Services Wizard and Object Dialog Boxes
- 6.199 RESTful Services Connection
- 6.200 RESTful Services Privilege
- 6.201 RESTful Services Roles
- 6.202 Select Current Repository
- 6.203 Cannot Capture Table
- 6.204 Report Panel
- 6.205 Reset Expired Password (Enter New Password)
- 6.206 Revision Lister
- 6.207 Run/Debug/Profile PL/SQL
- 6.208 Create/Edit Breakpoint
- 6.209 Save/Save As, or Select File
- 6.210 Save or Open Cart Tool Configuration
- 6.211 Save Files
- 6.212 Unable to Save Files
- 6.213 Save Style Settings
- 6.214 Schema Differences Source or Destination Error
- 6.215 Script Execution Failed
- 6.216 Script Generation Complete
- 6.217 Set Data Mapping
- 6.218 Add/Edit Rule
- 6.219 Set Encoding
- 6.220 Set Pause Continue
- 6.221 Shared Wizard Pages
- 6.222 Sign In (checking for updates)
- 6.223 Single Record View
- 6.224 Save Snippet (User-Defined)
- 6.225 Edit Snippets (User-Defined)
- 6.226 Show SQL
- 6.227 Start Date, End Date, Repeat Interval, Comments (Scheduler)
- 6.228 Subversion: Add Property
- 6.229 Subversion: Add to Source Control
- 6.230 Subversion: Apply Patch
- 6.231 Subversion: Branch/Tag
- 6.232 Subversion: Check Out from Subversion
- 6.233 Subversion: Commit Resources
- 6.234 Subversion: Commit Working Copy
- 6.235 Subversion: Confirm Checkout
- 6.236 Subversion: Create Remote Directory
- 6.237 Subversion: Create Subversion Repository
- 6.238 Subversion: Create/Edit Subversion Connection
- 6.239 Subversion: Delete Resources
- 6.240 Subversion: Edit Configuration File
- 6.241 Subversion: Export Files
- 6.242 Subversion: Export Subversion Connections
- 6.243 Subversion: Ignore
- 6.244 Subversion: Import Subversion Connections
- 6.245 Subversion: Import to Subversion
- 6.246 Subversion: Lock Resources
- 6.247 Subversion: Merge
- 6.248 Subversion: Pending Changes
- 6.249 Subversion: Properties
- 6.250 Subversion: Remove from Subversion
- 6.251 Subversion: Repository Browser
- 6.252 Subversion: Revert Local Changes
- 6.253 Subversion: Switch
- 6.254 Subversion: Unlock Resources
- 6.255 Subversion: Update Resources
- 6.256 Subversion: Update Working Copy
- 6.257 Subversion: Versioning Properties
- 6.258 Third-Party Database Objects
- 6.259 Unable to Connect
- 6.260 Unable to Open File
- 6.261 Uninstall Oracle REST Data Services
- 6.262 Unplug Pluggable Database
- 6.263 Unsupported Database Version
- 6.264 Validate Geometry
- 6.265 View Whole Value
- 6.266 Windows
- 6.267 XMLType Column Properties