Discussions
Categories
- 382.2K All Categories
- 2.1K Data
- 208 Big Data Appliance
- 1.9K Data Science
- 447.9K Databases
- 220.9K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 521 MySQL Community Space
- 465 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 490 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.1K SQL & PL/SQL
- 21K SQL Developer
- 293.2K Development
- 7 Developer Projects
- 127 Programming Languages
- 289.9K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 260 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
New Release: 19.3.3. Lots of features! Try it out and let us know what you think
Please let me know what you think.
We have added SQL*Plus support. See these web pages:
SQL*Plus common commands: https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodesqlplus.html
SQL*Plus Reference:
https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodesqlplusref.html
More features from the changelog:
Changes in version 19.3.3
- Connection Dialog enhancements: Set/Change the current schema, improved proxy user connection UI
- Improved connection failure detection with an option to reconnect
- Support for macOS connections to Oracle Autonomous Database over TLS
- Support for database connections using LDAP
- Browse other schemas ("Other Users" node) in Oracle Explorer tree control
- SQL History and Bookmarks
- Limited SQL*Plus support
- Detection and warning of unsupported SQL*Plus commands in scripts (and child scripts)
- SQL*Plus CONNECT command associates the file with a connection
- Preservation of all session associated properties from execution to execution
- Autocommit On/Off setting
- Autocompletion of SQL*Plus commands
- Autocompletion of procedure/function parameters
- Intellisense/Autocomplete performance enhancements
- Syntax coloring for SQL and PL/SQL keywords and SQL*Plus commands/variables
- Append new results to existing results window
- Toolbar buttons to cancel running query and to clear results window
- Setting to automatically clear results window after each execution
- Remember previous selections in some UI elements and offer as defaults
- Support for REFCURSOR variables and implicit cursors
- Visual Studio Code theme support for Light/Dark/High Contrast themes
Comments
-
IF you could just get autocomplete working against aliased table names it would be usable in place of SQL developer.
-
Amazing updates thank you! I may be being dumb but how do I connect with a proxy login, I have done the "more options" but can't work out which username should be which. Usually in SQL dev my username would be personal_schema[proxy_schema] and use my personal schema password, how do I translate that to these options?
-
This would be huge (although it doesn't work amazingly for me in SQL Dev anyway due to the size of our database).
-
I find 3 bug ( performance & intellisense)
- the shema combobox freeze VS code with lot of schema ( please virtualise or limit number of items showed without filter)
- the filter tree is slow
- autocomplete doesn't work in this case
SELECT * FROM SCHEMA.TABLE t WHERE t.[autocomplete],i try it with SQL and PL/SQL
Idea :
- add a TextBox filter on user/table , its currently difficult to navigate on this
important:
- you need a beta/preview chanel for you extension it will help oracle :)
-
Managed to get it to work, the User Name is the bit in [], do not enter a password. The proxy User Name is the personal_schema before the [], and the proxy password is the password for that schema.
-
Hi, sorry for the confusion. I will update the Quickstart to make it easier for anyone else trying to do this.
-
Hi Adil,
Thank you for the bug report - it is very valuable. 😀 If you have any more feedback in the future please continue to let us know here on this forum so we can improve the product.
-
Hi Adil,
We'd like to get more information about the schema combobox slowness. Could you please execute the following script against the same database you are connecting to when you try to use that combo box? (eg connect first without setting the combo box and then run this script)
spool c:\temp\timings.txt
set timing ON
select count(*) from all_users;
SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME;
set timing off
You could post the results here or email the timings.txt file to me at christian (dot) shay (at) oracle (dot) com
-
Hi,
here the result ( i hide the users name for confidentiality),
I think, the problem seems to be front-end (the combobox try to show the 20 891 USER and freeze vscode)
SQL> set timing ON
SQL> select count(*) from all_users;
COUNT(*)
----------
20891
Elapsed: 00:00:00:29
SQL> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME;
USERNAME
--------------------------------------------------------------------------------
XXXXXX
Elapsed: 00:00:00:05
SQL> set timing off
-
Hi again Adil,
sorry, I thought I replied to this already - I passed this on to our developers and we will fix this in the next release.
In the meantime can you please try the following workaround?
1) Don't click on the Schema drop down, instead just click on the text area.
2) Then, just type the name of the schema you want to use.
My understanding is that this will avoid fetching all the schemas and will let you proceed with the schema of your choice.
Could you try that out and let me know if it works for you?