Menu
Is there a way to color code the database connections within Oracle SQL Developer? I know that TOAD can do this. I want to make prod have a RED background and DEV with a green background, to make it easy to know which system I'm working on at any moment.
Cheers
215
You can change the font style, as well as the foreground and background colors used in syntax highlighting within the source editor in the Tools > Preferences > Code Editor > PL/SQL Syntax Colors page.
No, there is no official method. There is a way to change it manually through, through editing a jar file. Here is the full video if it helps you out. By default you can only change the Syntax colors + background of the editor.
In SQL Developer, Preferences->Database-> NLS , if you change the Decimal Separator setting, you also need to make sure that your new setting doesn't conflict with the existing Group Separator setting.
Yes. New feature for version 4.0
Connection has 'Connection color' property. This color will be painted to the border of each editor assigned to that connection.
In addition the connection name in the tree and any new connection picker/dialog will also be labeled with that color.
147
You can vote for this feature on Oracle SQL Developer Exchange.
33
You can't color code them currently. I prefix my Production connection with an asterisk to indicate the same thing (since I don't want to have to expand folders each time).
My Connections pane looks like this:
Connections
|+ "Unused" (folder for rarely used connections)
|- "*PROD* - user@tnsalias"
|- "DEV - user@tnsalias"
|- "TEST - user@tnsalias"
I find it helpful to include the user and tnsalias in my connection name so it's clear to see how and where I'm connecting.+
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
