1 Getting Started with Oracle Developer Tools for VS Code

Welcome! Oracle Developer Tools for VS Code enables Visual Studio Code developers to connect to Oracle Database and Oracle Autonomous Database; edit SQL and PL/SQL with IntelliSense, breadcrumbs, Hover, and Go To/Peek; execute SQL and PL/SQL and view and save the results; and debug PL/SQL using VS Code's native debugging features. The Oracle Database Explorer tree control allows you to quickly explore your database schema, view table data, and edit, debug, execute and save PL/SQL. Create and manage Oracle Autonomous Databases (ADBs) using Oracle Cloud Infrastructure Explorer tree control. Create, start, stop and terminate ADB instances, and automatically create a walletless database connection or download credentials files.

This Quick Start will help you install, connect, configure and get started using Oracle Developer Tools for VS Code.

Note:

This document assumes you are using version 23.4.1 (released August 2024). Follow the instructions for updating in Installing and Updating Oracle Developer Tools for VS Code if you are using an older version.

• Installing and Updating Oracle Developer Tools for VS Code
  
• 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 to Oracle Autonomous Database (ADB)
  
• 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
  
• Using Select AI: Natural Language to SQL
  
• Viewing an Explain Plan/Execution Plan for a SQL Statement
  
• Using Real-Time SQL Monitoring
  
• Formatting SQL and PL/SQL with a Configurable Formatter
  
• Using Lowercase/Title Case 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
  
• Viewing SQL History
  
• Creating a SQL Bookmark
  
• Generating JavaScript, Python, Java, and C# Data Access Code
  
• Configure the Location of the Query Results Window
  
• Creating and Modifying Keyboard Shortcuts