Installation

To use Oracle SQL Developer Extension for VSCode, you will need to install it on VSCode. Follow the steps below to set it up:

1. Open Visual Studio Code.
2. Go to the Extensions view by clicking on the Extensions icon in the Activity Bar on the side of the window or by pressing Ctrl+Shift+X.
3. In the search bar, type "Oracle Developer Tools for VS Code".
4. Find the extension in the search results and click on the "Install" button.
5. Once installed, you may need to reload VS Code to activate the extension.

Connection

After installing the extension, you need to configure it to connect to your Oracle database:

1. In the VS Code terminal, run the following command

   ssh -N -L 1522:dbhost.students.cs.ubc.ca:1522 your_cwl@remote.students.cs.ubc.ca

   This will open a tunnel to the DB server which is required since it is hosted on the remote server. You will need to run this EVERY TIME you want to connect to the database. There will be no output if the command is successful.

2. Open the SQL Developer extension on the Activity Bar on the left side.
3. Click on 'Create Connection'.
4. Input the connection details as specified below.
5. Click 'Test' and verify that it works.
6. Press Save so that the connection is saved.

Connection Details:

• Connection Name: Oracle DB (or whatever name you want)
• Username: ora_CWLID
• Password: aSTUDENT_ID
• Save Password: Yes
• Connection Type: Basic
• Hostname: dbhost.students.cs.ubc.ca
• Port: 1522
• Service Name: stu

If everything is successful, you should be able to see all your tables. The main tabs that are important are Columns (table schema) and Data (rows).