2.1 Installing Oracle SQL Developer for VS Code

Oracle SQL Developer for VS code is available for all major platforms.

Perform the following steps to install Oracle SQL Developer for VS Code:

Note:

After installing it the first time, the SQL Developer extension for VS Code is automatically updated as new versions become available.

1. Click the Extensions icon in the Activity Bar on the left side or use the View: Extensions command (Ctrl+Shift+X).
2. In the Extensions pane, in the Search field, enter SQL Developer.

   SQL Developer appears as one of the search results.

3. In the result entry, click Install.

   SQL Developer appears in the left pane under INSTALLED along with a SQL Developer icon in the left side bar.

4. Click the icon to open SQL Developer. In the left pane, Connections and SQL Snippets appear.
   
   Description of the illustration install_sqldev_icon.png

2.1.1 File Permissions for User Accounts in Windows Domain

If there are both local and domain accounts for a user in Windows, the directory is assigned to the local account, creating inaccessible secure storage for the domain account. That is, a DBTools directory owned by the local user is created in the domain user's AppData\Roaming location.

To resolve this issue:

1. Uninstall SQL Developer for VS Code release 23.4.0.

2. Remove the DBTools directory.

   As the domain user, if you try to open <domain-user>/AppData/Roaming/DBTools, you will get an error message.

   

   To resolve this, do one of the following:

   • If you are also an administrator, you are prompted for access, then you can delete the directory before installing a new version.
   • If you are not an administrator, contact an administrator who can help to delete the directory.

   • If you know both local and domain passwords, provide local account access to your domain user directory.

     

     Ignore any errors as the focus is on the path to AppData\Roaming\DBTools.

     Permissions are as shown in the following figure:

     
     Description of the illustration file_permissions.png

     Log in as local user and navigate to <domain user>\AppData\Roaming, and then delete DBTools.

     Log in as domain user and remove local account access to the domain account home directory.

     
3. Install SQL Developer for VS Code release 23.4.1.