VS Code extension: Oracle
In case you work with Oracle DB and VS Code you might want to use the extension that Oracle prepared for VS Code. You can find it here. I will present my point of view how to quickly get started with it, however, you can also read an official quick start guide.
The first thing you need to do is to add a new connection. This can be done by opening the extension itself and selecting to add new connection:
It supports Basic (service name), TNS, Advanced and ODP.NET type of connection.
After you have connection set up, you can either open a new query window or open an existed supported file. Supported files are *.sql, *.plsql and *.pls. In case you have had a file open beforehand, or you did not open it through the Oracle extension, you will first have to connect. You can connect by opening the command palette and selecting "Oracle Connect" and then the connection to the DB that you want to work with. If you want to open a new file or open an existing file via the extension, you can skip that step.
Once you write a valid SQL query, you can either execute the whole file or a current statement. I suggest you to set up short keys in order to be able to execute it faster. By default, execute all has a short key CTRL+R and execute SQL is CTRL+E.
The query brings you a rich auto-complete that is offered in IntelliSense and/or by pressing CTRL+SPACE.
Results are displayed in a new results tab.
On the sidebar you have Bookmarks for often used queries and history of your executed queries. There is also Oracle Cloud infrastructure, however, I have not tested this yet.
It might not be a replacement for your daily DB IDE, however, in case you spent some time in VS Code I find it very useful to modify an existing script file open in my workspace or to do quick queries/modifications to the Oracle DB.
- Previous: Git return to previous branch
- Next: VS Code extension: Thunder Client