It is tested on Oracle Database 11.2.0 with 32-bit and 64-bit Oracle client libraries(windowns 10).
After installing the oracle Driver for SQLTools, you will be able to create connections to oracle Database, explore tables and views, and run queries. For more information on how to use SQLTools please refer to SQLTools extension
For 64-bit Oracle client libraries
Have 64-bit Node.js (version 10 or newer) and npm installed
Have the firstname.lastname@example.org (Normally, Upon first use the Oracle driver extension prompts for permission to install the email@example.com package).
For 32-bit Oracle client libraries
Have 32-bit Node.js (version 10 or newer) and npm installed(nvm can be used to manage different nodejs versions)
Have the firstname.lastname@example.org(Because there is no prebuilt binaries corresponding to this platform, you need to install according to the official instructions) in the specific directory(which is used for storing data for vscode-sqltools)(you can use everything to search "vscode-sqltools" to find the directory)
For me, I first download the tgz File, then in the **\AppData\Local\vscode-sqltools\Data directory and run npm install your_dir_path/oracledb-5.5.0.tgz