DB connection

[Danieleeee]

Is possible to have the Oracle DB connection like mssql and vscode-database exstensions do?

[zabel-xyz]

That would be great ! ...
I already thought of doing something like that, auto-complete list of tables, fields, procedures through a DB connection..
But I do not have enough time to do that right now. Perhaps an improvement for the future...
But you or someone else can always suggest a PR to do that...

[Danieleeee]

Oracle Database driver for Node.js maintained by Oracle Corp.
https://github.com/oracle/node-oracledb

[Danieleeee]

Can you transfer this Sublime extension sublime-sqlexec in VSCode with Yeoman?
With it you can connect to Oracle DB and make query an so on...

[Danieleeee]

Can see Oradew extension

[zabel-xyz]

I'm going to implement a connection via https://github.com/oracle/node-oracledb...

[Danieleeee]

Hi,
regarding auto-complete list (or selects), can you consider the possibility to enable the functionality also on different schemes of the same DB SID?
For example:
I am in the "SVIL" DB with 3 schemas (ute1, ute2, ute3).
if I am logged in as "ute1" and I write the name of a table / procedure that is on ute2 but not in ute1, autocompletion should still propose the results.

Thanks and good job

[zabel-xyz]

Version 1.6.0: first feature with oracleDB connection - Run current command (No auto-completion yet)
To activate it plsql-language.oracleConnection.enable
For information, see readme