search

zabel-xyz / plsql-language

plsql-language for vscode
MIT License
79 stars 29 forks source link

DB connection #9

Open Danieleeee opened 7 years ago

Danieleeee commented 7 years ago

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

zabel-xyz commented 7 years ago

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 commented 7 years ago

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

Danieleeee commented 7 years ago

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 commented 6 years ago

Can see Oradew extension

zabel-xyz commented 6 years ago

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

Danieleeee commented 6 years ago

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 commented 6 years ago

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