Change SQL Query Statement font [message #158068] |
Wed, 08 February 2006 06:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
While PL/SQL formula window uses non-proportional font (Courier, I'd say, which is easy to read), SQL Query Statement window (the one used for writing report queries) uses proportional font (Arial or similar font). Although structured, queries viewed in this window look awful.
Is it possible to change SQL Query Statement font to Courier, for example? I checked "Edit - Preferences", but didn't find anything alike. Is there any other place I should look? Perhaps some kind of the "default.env" file for Report Developer?
[Updated on: Wed, 08 February 2006 06:29] Report message to a moderator
|
|
|
Re: Change SQL Query Statement font [message #158076 is a reply to message #158068] |
Wed, 08 February 2006 07:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
benoitchabot
Messages: 15 Registered: October 2005 Location: Quebec , Canada
|
Junior Member |
|
|
You can change the font in SQL*Plus for Windows NT/2000. So far, I have only managed to make this work in SQL*Plus 8.1, 9.0 and 9.2
In regedt32, go to
HKEY_LOCAL_MACHINE
-> SOFTWARE
-> ORACLE
-> HOME0
Create a new registry value called SQLPLUS_FONT of type REG_EXPAND_SZ and set it to your favourite fixed-width font, Eg. Courier New
Create a new registry value called SQLPLUS_FONT_SIZE of type REG_EXPAND_SZ and set it to the size you want (16 is a good size).
Benoit Chabot
|
|
|
|