There are problems using code completion when you want to switch from SQL Developer or Toad to VS Code. The thing is that Github Copilot do a better completion job than SQL Developer for my PL/SQL files. What Copilot lacks I could just write 30-40 snippet well organised and that would do the trick.
The first problem is that when I write my own snippets, they are mixed with hundreds of useless snippets from the plugin. I wish we could just clear default snippet from the plugin since they are not useful in certain case like mine.
The second problem is that the code completion is based on the connected user and not on the compilation user where our code is actually stored.
So to summarize :
- Is it possible to disable all SQL Developer for VS Code default snippets?
- Is it possible that configure the plugin to complete packages name with a specific schema?
- Exemple : I log in a USERNAME1 and I compile and work in schema GLOBALWEB. What I need completed is in GLOBALWEB not in USERNAME1.
Is there any way around that?
Here is an exemple :
