Jan 9, 2019 · 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. You can vote for this feature on Oracle SQL Developer Exchange. You can't color code them currently.

Sep 30, 2011 · In SQL Developer can I get the result of a SQL query in color? For example: Select * from Employee; If EmployeeID = 100 I want the name column to be displayed in green color. If EmployeeID = 200 I want the name column to be displayed in red color. All other fields (gender, salary) should be in normal colors. The reason I am asking for this:

Jan 10, 2023 · In order to be careful when executing queries, we would like to change SQL Developer themes by connection or change the Query sheet. Thank you, I'm looking for changing the whole theme, like change the background color to other color than plain white.

Jul 2, 2009 · Does anyone know a way to configure SQL developer so that different connections have different colour schemes? I'd like to ensure I always know when I'm working on the live database, for example, rather than just looking at the connections drop down in …

Sep 12, 2013 · - Connections to display as in groups. - Each group and connection of that group can be color coded (say production connections are displayed in Red color, Testing/Staging are displayed in Yellow, Development in Blue etc)

Looking for a way to set a different background color in the command window for a specific connection. Is there a way to do this? The intention is to have some sort of visual cue when I am connecting to the production database to prevent accidents.

Using the SCRIPT command to invoke some javascript at connect time, we can see who your user is and what your SERVICE/SID is and update your prompt dynamically. Again, example here thanks to Kris. sqlcl. setStmt('set sqlprompt "@|red _USER|@@@|green _CONNECT_IDENTIFIER|@@|blue ?? >|@"'); } else { .

Apr 22, 2019 · Today I want to highlight some changes we made to how you define your connections. One change you’ll see right away is a simpler connection dialog: The name and color of the connection is up top now, and it’s hopefully less likely you’ll type your password into the username input area by accident!

Oct 16, 2018 · Are you Looking for a way to set a different background color in the command window for a specific connection? Is your intention is to have some sort of visual cue when you are connecting to the production database to prevent accidents? Solution: Yes! …

For example: Select * from Employee; If EmployeeID = 100 I want the name column to be displayed in green color. If EmployeeID = 200 I want the name column to be displayed in red color.