Your feedback wanted: New Update to Oracle Developer Tools for VS Code version 19.3.1 (released 7/31/19)

Hi.

Is there away to use proxy connections.

the userid[proxyid] syntax does not work.

Thanks.

Hi,

Will there be the ability to alias table names? (SELECT TB.COLUMN1, TB.COLUMN2 FROM TABLE1 TB). It's fairly inconvenient and verbose to have the full table name when selecting 10 columns from a table.

Thanks.

Hello,

thank you for developing this extension! I like it so far but I also think there is some room for improvment.

What is very distracting for me is the current color scheme of the code. Let me give you an example.

On the left is how my code looks with the Language PL/SQL Extension https://marketplace.visualstudio.com/items?itemName=xyz.plsql-language

On the right is how my code looks with your extension.

I think the left one is much more readable. So it would be nice If you could change the colors or let the users configure them somehow.

And another suggestion:

We have a big database with many schemas und a development user with access to all of them. But I cannot browse the schemas in the Oracle Exporer tab. I see only the schema of the current user. As my dev user has no tables and no packages the whole tab is kind of useless for me.

So please provide a possibility to browse the available schemas of the database.

Edit: I also noticed that because of this i'm not able to use intellisense.. It only uses the db objects from the current user and I have none . This is really sad because  intellisense would be an awswome feature to have.

It would help so much I you could configure all the schemas you want to use for each connection!

Edit2:

Oh actually it does work if i use the full name of object (schema.name.subname). That is nice

Thank you for this great job !

One feature that miss is the possibility to copy paste value from result tab and make a row count as on sql developer (right click -> row count)

How to shut up the extension about logging in as admin/non-admin? It's rather annoying to tell it every time, and the extension settings aren't documented anywhere, nor they have helpful tooltips.

I mean, how helpful is "Specify connection lifetime" tooltip to a "connectionLifeTime" parameter? Same goes for "contextConnection", "dBAPrivilege" and majority of other parameters.

I keep receiving an exception : Could not load System.DirectoryServices.Protocols version 4.0.0

I really want this to work. It would be the lightest weight Oracle client there is. Perfect for quick queries and the like.

That did the trick! Thank you. I look forward to exploring this extension.