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!
I have sources of my packages stored in files with pkb and pks extenions. Oracle Developer Tools for Viusal Studio do not recognize it as sql so no syntax is highlighted. Can it be changed so they are properly recognized as sql files ?
should be straight forward.
Click on 'select language mode' -> Configure file association for '.pks' -> choose language mode you want.
That's visual studio CODE. OP is asking about Visual STUDIO. Doesn't seem to be a way to do this… as ODT doesn't appear as an editor in the dropdown:
Hi there, In Visual Studio we don't yet have a full featured sql script editor like we do in VS Code.
We have a “Query Window” where you can type or cut and paste SQL and we have Tools→Run SQL Plus script menu item.
You can also open any file into Query Window like so:
In a future release we hope to merge everything so that the behavior is much like the editor in VS Code, supporting scripts, opening files for edit, etc.