1. Start Visual Studio Code
2. Select Extensions
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-12.png)
3. search for : Oracle SQL Developer Extension for VSCode and click ‘Install’
Oracle SQL Developer Extension for VSCode
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-14.png)
4. Wait for several minutes for install to complete
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-15.png)
5. Database icon now is visible on the leftside ribbon, select this then select Create Connection
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-17.png)
6. Complete connection dialogue information, example below
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-18.png)
7. Test, Save, then connect
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-19.png)
8. Open SQL worksheet, right click connection, the select Open SQL Worksheet
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-20.png)
9. Run a query using play button and view results
- you can also press ‘CTRL’ + ‘Enter’ at same time to run the sql
![](https://www.snowdba.com/wp-content/uploads/2024/05/image-21.png)