Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 159 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 471 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
VS Code - Syntax Highlighting Conflict

Hello
Is there a way to turn off ODT for VS Code's native syntax highlighting?
The theme I'm using should display SQL as shown below (note the grey-blue of column names, aliases, table names etc, and the light blue for recognised functions like Count():
When I have the ODT for VS Code extension turned on, it seems to override some of my selected theme's syntax highlighting and leaving the aforemention bits of text white:
Other than enabling/disabling the extension, I can't see a way to stop this.
Thanks, Matt.
Answers
-
Hi Matt,
There's currently no setting to disable syntax coloring. You could click the Oracle-SQL and PL/SQL language mode at the bottom in the status bar and temporarily associate the file with a text editor if a patch of text is messing you up, but I realize that is not a very good solution.
What theme are you using?
-
Thanks Christian. I'm using the Better_JS theme (I've adapted a couple of colours here and there).
-
Hi,
I was a bit distressed by your situation 😯 so I did some googling. I found this long github thread about themes per language:
https://github.com/microsoft/vscode/issues/20652
..and it seemed to be resolved by this extension:
While not the perfect solution, maybe you can use it to choose a different (or tweaked) theme just for our extension that looks better given our syntax coloring choices.
If you decide to try this, can you please let me know if it helps?
-
Thanks for digging that out.
I ran the the following commands for the Theme by Language extension you linked me to:
Clear all registered custom themes for file languages
Set theme for current file language > Better_JS
But unfortunately the ODT's formatting still seems to take precedence for certain parts of the code and formatting text as white:
-
Is the formatting specified in one of the ODT files... perhaps I could just change it to match the theme I use (I don't tend to use others ones at the moment).
-
It is true that we will force different colors as we highlight, but what I meant for you to do is to use a different theme than Better_JS or a customized version of that theme just for our extensions where you you find there are no conflicts or the color scheme is acceptable to your eyes. Maybe you can try various themes with our extension and find one where our colorization choices don't hurt your eyes? (That may not exist of course 😯)
-
Oh I see, my apologies - find a theme that harmonizes well with ODT's syntax highlighting.
TBH, I can live with the white text, just would prefer to be able to use the selected theme's colours (i.e. have the option to turn off ODT's syntax highlighting colours).
Thanks for taking a look at this for me 🙂
-
Right, and please note that in other themes, we do not use white (for example, default dark).
So there may be a tweak to the background color that you can do that changes our color, etc. It will take some experimentation.
I will add this setting to a list of feature requests I am maintaining and hopefully we can address it in a future release.