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!

Using HOST command to customize the foreground and background

Ron192Apr 25 2017 — edited Apr 25 2017

I can set my foreground and background colors in my terminal window using a COLOR command, but I like to change the colors when changing connections from a production database to a test database using the CONNECT command.  I can accomplish this in SQLPlus using a connect script that has "HOST COLOR FC" in it, and that works fine.  When I try the same thing in SQLcl, it changes the color of everything in the current window, but reverts back to the original colors as soon as I do a new query.

Does anyone know how to change the foreground and background colors without having to exit SQLcl?  I'm thinking there should be something similar to using the dot syntax in unix where you prefix a command with a period space to make it run in the current shell.  i.e. ". HOST COLOR FC"

Comments
Post Details
Added on Apr 25 2017
1 comment
659 views