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!

sqlprompt with particular colors - how my login.sql should look like?

User_A36HOJan 2 2018 — edited Jan 3 2018

Hello -

In my sqlcl prompt currently looks like this

SCOTT@ORCL >

with no particular colors.

Let's say, i would like to have "SCOTT" in green color and "ORCL" in red color.

How this can be done by editing my login.sql file?

SET sqlprompt "' '_user '@' _connect_identifier >"

Thank you,

vr - i love sqlcl

Comments
Post Details
Added on Jan 2 2018
11 comments
1,251 views