Skip to Main Content
Forums

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.

Does "Oracle Developer Tools for VS Code" support SQL*Plus commands like DEFINE, SET, VARIABLE, and

m971668Mar 11 2020 — edited Apr 8 2020

Does "Oracle Developer Tools for VS Code" support SQL*Plus commands like DEFINE, SET, VARIABLE, and @?
Basically, to run external scripts in other files on the client computer.

e.g.:

set feed off

set define on

set verify off

define db_base = 'C:\main\db\'

set feed on

@"&db_base.dummy.pks"

@"&db_base.dummy.pkb"

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/SQL-Plus-command-summary.html#GUID-71DD7D4A-70C1-4E3…

This post has been answered by Christian.Shay -Oracle on Oct 8 2020
Jump to Answer

Comments

Christian.Shay -Oracle

Hi, right now we do not, however this will be added in the 19.3.3 release (coming soon!)

Answer

Limited SQL Plus command support is now available in the new 19.3.3 version. Please try it out and let me know what you think.
See this links for details of what is supported:
Using SQL*Plus Commands with Oracle Developer Tools for VS Code (0 Bytes)Oracle Developer Tools for VS Code - SQL*Plus Command Reference (0 Bytes)

Marked as Answer by m971668 · Oct 9 2020
1 person found this helpful
1 - 2

Post Details

Added on Mar 11 2020
#oracle-developer-tools-for-vs-code
2 comments
427 views