Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

New Release: 19.3.3. Lots of features! Try it out and let us know what you think

Christian.Shay -OracleOct 1 2020 — edited Oct 8 2020

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

top.gun

So there is nothing to vote for?

William Robertson

This seems to be a tip rather than a suggestion for Oracle to implement something new.

Chris Hunt

And your suggestion is?

I wouldn't bank on any of these options "improving the performance." The Oracle optimiser is pretty clever, and may well use the same query plan in all three cases.

Akshs

And your suggestion is?

I wouldn't bank on any of these options "improving the performance." The Oracle optimiser is pretty clever, and may well use the same query plan in all three cases.

Could you please go through the below link where I attached the explain plan.

Martin Preiss

as others I fail to see here a proposal of a new feature - since the optimizer is already able to do corresponding transforms internally.

Furthermore I think it's common knowledge that NOT IN will not return a result set when the subquery contains NULL values.

unknown-1040115

This may not be an actionable idea for the Database Ideas list...

May I suggest we adjourn to the space to continue the discussion.

LKR

Akshs

This may not be an actionable idea for the Database Ideas list...

May I suggest we adjourn to the space to continue the discussion.

LKR

Thanks for guiding me.

But I tried to publish in SQL PLSQL Space..But because of permission issue I'.m not able to publish...

unknown-1040115

Thanks for guiding me.

But I tried to publish in SQL PLSQL Space..But because of permission issue I'.m not able to publish...

I can move this on your behalf.

Regards,

LKR

Akshs

I can move this on your behalf.

Regards,

LKR

Thank you....

Akshs

I can move this on your behalf.

Regards,

LKR

Even I'm not able to send any message. Could you please publish the below document in SQL PL\SQL space.

Could  please accept the request, So I'm able to message you.

Akshs

I can move this on your behalf.

Regards,

LKR

Hi Laura,

I have just published a document. Kindly move it to SQL and PLSQL space.

Document path : -

Many Many Thanks

Akshs

1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2024
Added on Oct 1 2020
67 comments
1,625 views