- 3,715,830 Users
- 2,242,890 Discussions
- 7,845,632 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 472 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 5 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 417 SQLcl
- 42 SQL Developer Data Modeler
- 184.9K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 9 DevOps
- 3K QA/Testing
- 254 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 66 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 11 Español
- 1.9K Japanese
- 2 Portuguese
VSCode requests

Alias auto-complete. Also I want to setup a schema so that it is the default one per connection. I don't want to enter it every time for intellisense to work
Parameter support. Let us add parameter values and types on the query when they are detected on the file like ":THEDATE". It should remember every value and parameter type on any future file/season using a history file? with values/types per parameter names!
Show script. (shortcut) when on any object/table/view/procedure/package etc it should open the DML sql script of it on a separate tab so i can change it.
Run current query. (shortcut) (without selecting it). Parse the file I'm in and detect the current query that is between two blank lines and execute it.
Result page customization. Maybe add horizontal split support, color changes etc!
Comments
-
The problem here may be my lack of know-how, but how about script output?
-
We just released a new version of the extension ( version 19.3.1, released 7/31/19) which among other things includes a Oracle Database Browser tree control. I believe it addresses your "run current query" request. Please try it out and let us know what you think. If you don't have automatic updated enabled see the quickstart for instructions on how to update:
https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodequickstart.html
For result page customization, we have made horizontal split easier. See the bottom of the quickstart for more info.
-
Cool, Christian!
I haven’t succeeded at discovering how can I browse a schema other than my current logged in account?
Any tips?
Thanks!!
Geoff Switz
-
I'd like to echo what 3433534 is saying: In my shop, management is moving away (quickly) from giving developers the schema owner credentials and instead, using Oracle User Proxies - even in DEV. For a lot of what I do now, I have drop out of Visual Studio and VS Code, go to SQL Developer, do my thing, then hop back. SQL Developer is a good product, but with the best of all worlds I could do it all in one tool, whether VS or VS Code. - jdb
-
2846126 wrote:I'd like to echo what 3433534 is saying: In my shop, management is moving away (quickly) from giving developers the schema owner credentials and instead, using Oracle User Proxies - even in DEV. For a lot of what I do now, I have drop out of Visual Studio and VS Code, go to SQL Developer, do my thing, then hop back. SQL Developer is a good product, but with the best of all worlds I could do it all in one tool, whether VS or VS Code. - jdb
You will need to use a ODP.NET connect string if you want to use proxy authentication. We'll try to improve this soon:
Use option "New Connection"
When prompted for connect string, enter:
User Id=testuser;Data Source=localhost/XEPDB1;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
-
Using EZ-Connect strings within an ODP.NET connect string seems to a make a world of difference. I'll try this some more over the next few days and get back to you. Thanks. - jdb
-
Please check out our latest 19.3.3 release - we have addressed several of the issues in this thread. Let us know what you think!