Autocomplete different schema oracle

mtxr / SublimeText-SQLTools

SQLTools for Sublime Text 3

https://code.mteixeira.dev/SublimeText-SQLTools/

GNU General Public License v3.0

177 stars 40 forks source link

Autocomplete different schema oracle #112

Closed calope closed 7 years ago

calope commented 7 years ago

Issue Type

[x] Feature Request - Oracle.
[ ] Bugfix/Errors
[ ] Questions
[ ] Other

Prerequisites (For bugfixes)

[x] Are you running the latest version?
[ ] Did you check the logs?
[ ] Did you check the Setup?

Description

I trying to autocomplete the name's column but only works with schema's table. I trying to change the schema execute this sentence ALTER SESSION SET CURRENT_SCHEMA =

But doesn't autocomplete. Only with the schema connection.

Versions

Version: v0.9.2
OS: All
RDBMS: Oracle

tkopets commented 7 years ago

Right now for Oracle we get only identifiers related to the current schema, and this can be easily changed to pull all available identifiers. The problem with trying to set: ALTER SESSION SET CURRENT_SCHEMA = is that every statement you execute is executed in new sqlplus process, so your session state is not saved between commands (DB connection is not persistent, but rather new connection is opened every time you execute the command). I'll make the appropriate change to pull identifiers from all schemas, so they are available for completions.

tkopets commented 7 years ago

Prepared a new release with this improvement.

calope commented 7 years ago

Thank you very much!!!

tkopets commented 7 years ago

Let me know if the new version works as expected. It may take several hours before new version will be available in PackageControl.

calope commented 7 years ago

Ok.

calope commented 7 years ago

It works great!!!

Several schema tables':

captura de pantalla 2017-06-02 a las 14 42 28