Martijn -- Thanks for the question regarding "Change font color in SQL*Plus", version 10.2.0.1.0

You Asked

Hi Tom,

I'm pretty sure that recently I stumbled upon an article on some Oracle blog, demonstrating how to change the color of fonts in SQL*plus. (No HTML etc., just the (server)output in SQL*Plus)

Unfortunatly I didn't bookmark it, can't find the blog anymore, but at this moment it would come in quite handy to make use this feature.

Hence my question: how can one change the color of fonts in SQL*Plus?
Thanks again.

Regards,

Martijn

and we said...

not sure about the color (that would be a terminal thing probably?)

but font and size:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch1.htm

Reviews

Changing font color in SQL*Plus (Windows Instant Client 10g)   July 12, 2007 - 12pm Central time zone Bookmark | Bottom | Top Reviewer: Ken Banyas from Greenbelt, MD USA I use SQL*Plus (from Instant Client 10g) on Windows XP. Right-click on its title bar, then select Properties. You can change font type (not many types), size, and color. Works fine for me. Ken Addendum to SQL*Plus font color change.   July 12, 2007 - 12pm Central time zone Bookmark | Bottom | Top Reviewer: Ken Banyas from Greenbelt, MD USA I also use the PuTTY terminal software to SSH from my Windows desktop to the servers. PuTTY also permits you to change pretty much everything on your term screen. Ken set   July 12, 2007 - 2pm Central time zone Bookmark | Bottom | Top Reviewer: A reader  i read some days ago on an Oracle Blog of one of the Oracle ACEs something about SET TRANSACTION READ ONLY would use client time cmp. http://tinyurl.com/37snja probably there is also an (undocumented) SET TRANSACTION COLORFONT lighseagreen and similar ? Thanks, and one more thing   July 12, 2007 - 4pm Central time zone Bookmark | Bottom | Top Reviewer: MHO from NLD I wasn't complete, pardonnez-moi for that: It should be possible to change the font color (more or less) conditionally, from a SQL statement, according to what I can recall from that blog... I.e.: print negative numbers you retrieve from a *SQL*Plus* query out in red ;-), in *SQL*Plus*. Hope I can find it back, and if I do, I'll post that method here too (unless someone else is faster/has better recall skills than me). Ironically enough, I got on that blog through Tom's meta-blog-list, after that, it's an infinite number of ORA-blogs, they're waaay to addictive ;) Thanks for your appreciated input, Tom and everybody! Regards, Martijn Color in sqlplus   July 13, 2007 - 3am Central time zone Bookmark | Bottom | Top Reviewer: Yas  Maybe this is what you are looking for. http://oracleandy.wordpress.com/2007/05/27/adding-some-colour-to-sqlplus/   July 13, 2007 - 5am Central time zone Bookmark | Bottom | Top Reviewer: Giovanni from Treviso, Italy This method does not work in Windows Env. - unfortunately. :( Thanks!   July 13, 2007 - 5am Central time zone Bookmark | Bottom | Top Reviewer: Martijn Hoekstra from NLD Thanks Yas! THAT was the exact link I was looking for! (but I should have used "colour" instead of "color"..) Regards, Martijn Colors in Windows Dos window   August 13, 2007 - 3pm Central time zone Bookmark | Bottom | Top Reviewer: Kamal Kishore from New Jersey, USA You probably do not have the ansi.sys driver loaded on your windows system. The color escapes work only when this driver is loaded. http://www.vfrazee.com/ms-dos/6.22/help/ansi.sys.htm

---

Write a Review