Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Conventions
  • Documentation Accessibility
• 1 Getting Started
  • 1.1 Installing Oracle SQL Developer for VS Code
    • 1.1.1 File Permissions for User Accounts in Windows Domain
  • 1.2 Connecting to Your Database
    • 1.2.1 Creating a Connection
• 2 Using SQL Developer for VS Code
  • 2.1 Working with Database Objects
    • 2.1.1 Tables
    • 2.1.2 Views
    • 2.1.3 Indexes
    • 2.1.4 Functions
    • 2.1.5 Packages
    • 2.1.6 Procedures
    • 2.1.7 Triggers
    • 2.1.8 Types
    • 2.1.9 Sequences
    • 2.1.10 Synonyms (Public and Private)
    • 2.1.11 Other Users
  • 2.2 Entering and Modifying Data
  • 2.3 Using the SQL Worksheet
    • 2.3.1 SQLcl Commands Supported in the SQL Worksheet
    • 2.3.2 Script Runner
    • 2.3.3 Explain Plan
    • 2.3.4 SQL History
    • 2.3.5 Using Snippets to Insert Code Fragments
  • 2.4 Running Functions and Procedures
  • 2.5 Using Preferences
• 3 Tutorial: Creating Objects for a Small Database
  • 3.1 Create a Table (BOOKS)
  • 3.2 Create a Table (PATRONS)
  • 3.3 Create a Table (TRANSACTIONS)
  • 3.4 Create Two Sequences
  • 3.5 Insert Data into the Tables
  • 3.6 Create a View
  • 3.7 Create a PL/SQL Procedure
  • 3.8 Use the SQL Worksheet for Queries
• 4 Third-Party License Information
  • 4.1 @emotion/react 11.11.1
  • 4.2 @emotion/styled 11.11.0
  • 4.3 @mui/material 5.14.18
  • 4.4 @muix-date-pickers 6.18.1
  • 4.5 @vscode/l10n 0.0.16
  • 4.6 ag-grid-community 30.2.1
  • 4.7 ag-grid-react 30.2.1
  • 4.8 babel-standalone 7.23.3
  • 4.9 cross-fetch 4.0.0
  • 4.10 dayjs 1.11.10
  • 4.11 isomorphic-ws 5.0.0
  • 4.12 Jetty 11.0.18
  • 4.13 JSZip 3.10.1
  • 4.14 monaco-editor 0.44.0
  • 4.15 react 18.2.0
  • 4.16 react-dom 18.2.0
  • 4.17 react-tabs 6.0.2
  • 4.18 react-window 1.8.9
  • 4.19 vscode-codicons 0.0.35
  • 4.20 vscode-languageclient 9.0.1
  • 4.21 vscode-webview-ui-toolkit 1.3.1
  • 4.22 winston 3.11.0
  • 4.23 ws 8.14.2