Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

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!

SQLcl handles 'host "COLOR XY"' badly in windows compared to SQL*Plus

User_3842UOct 4 2019 — edited Oct 5 2019

SQLcl handles 'host "COLOR XY"'' badly in windows compared to SQL*Plus. This is true for both powershell and cmd.

Below I have an example of the command 'host "color 47"' being run in SQL*Plus and behaving as expected, a completely red shell.

Then I have an example of the same command run in SQLcl and the colors are split between the original shell color and the new red color I wanted.

The result is SQLcl gets ugly very quickly as there is a strange mix of colors on screen, if you write enough into the shell then the red color disappears completely.

SQL*Plus

pastedImage_0.png

SQLcl

pastedImage_1.png

It would be good if this feature could be fixed.

The use case for changing the shell color is that if you set up a script to change the shell to certain colors depending on the database that you're in.

This can help with letting you know if you're in prod or dev at a glance.

Comments
Post Details
Added on Oct 4 2019
1 comment
455 views