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.
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
So there is nothing to vote for?
This seems to be a tip rather than a suggestion for Oracle to implement something new.
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.
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.
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.
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
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...
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,
I can move this on your behalf.Regards,LKR
Thank you....
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.
Hi Laura,
I have just published a document. Kindly move it to SQL and PLSQL space.
Document path : -
Many Many Thanks
Akshs