Table of Contents

• Title and Copyright Information
• 1 Getting Started with Oracle Developer Tools for VS Code
  • Installing and Updating Oracle Developer Tools for VS Code
    • Installing Oracle Developer Tools for VS Code
    • Updating this Extension
  • Creating and Managing Oracle Autonomous Databases (Oracle Cloud)
  • Configuring Walletless Connectivity and Network Access for Oracle Autonomous Databases (Oracle Cloud)
  • Exploring Database Schema with Oracle Database Explorer
  • Connecting to Oracle Database
    • Connecting Using Host Name/IP Address and Service Name
    • Connecting Using a TNSNAMES.ORA Connection Alias
    • Connecting Using a Proxy User
    • Connecting Using a Directory Server (LDAP)
    • Connecting Using OS Authentication
  • Connecting to Oracle Autonomous Database (ADB)
    • Connecting Using Oracle Cloud Infrastructure Explorer to Connect Without Using Credentials Files (Walletless)
    • Connecting Using Oracle Cloud Infrastructure Explorer to Automatically Download Credentials Files (Wallets)
    • Connecting Using Credentials Files Obtained Elsewhere
    • Connecting Without Using Credentials Files
    • Connecting Using OCI IAM Single Sign-on
  • Organizing Connections by User, Workspace, or Folder Scope
  • Applying Filters to Oracle Database Explorer and IntelliSense Suggestions
  • Changing the Default Schema for a Connection
  • Selecting a Default Connection to be used when Opening SQL files
  • Running a SQL Script Each Time a Connection is Established
  • Colorizing Oracle Explorer Connections and Code Windows
  • Viewing other Schemas in Oracle Explorer
  • Editing PL/SQL in your Database
  • Saving PL/SQL in Database to a File
  • Opening .SQL or .PL/SQL File
  • Changing Database Connection for an Open .SQL or .PL/SQL File
  • Creating a New .SQL or .PLSQL File
  • Using Auto Save when Editing PL/SQL
  • Executing SQL and PL/SQL
  • Viewing an Explain Plan/Execution Plan for a SQL Statement
  • Formatting SQL and PL/SQL with a Configurable Formatter
  • Using Lowercase Characters with Autocomplete/Intellisense
  • Navigating through SQL Scripts and PL/SQL Packages
  • Executing SQL*Plus Commands
  • Disabling and Enabling Auto Commit
  • Viewing and Saving Result Sets
  • Debugging PL/SQL
    • Debugging PL/SQL from Oracle Database Explorer
    • Debugging PL/SQL Called By an Application or SQL Scripts
  • Viewing SQL History
  • Creating a SQL Bookmark
  • Configure the Location of the Query Results Window
  • Creating and Modifying Keyboard Shortcuts
• 2 Learn What's New in This Version
• 3 Get Help or Provide Feedback