How to increase font size in SQL?

88    Asked by DavidEDWARDS in SQL Server , Asked on Jul 19, 2024

 I recently joined as a database developer for a particular company that can use Oracle SQL developer for database management. During a particular team meeting, a senior developer points out that some of the team members have been struggling with the default font size in SQL. Developers, especially when they are working with large scripts or even complex queries. To enhance the readability and ensure that everyone can work comfortably, I have been asked to find a solution to increase the font size in the tool. How can I increase the font size in Oracle SQL developer to improve the readability for all the team members? 

Answered by Diya tomar

 In the context of SQL, you can increase the font size in Oracle SQL Developer, however, you would need to modify the application setting. You can follow these steps so that you can change the font size for better readability:

Open SQL developer

Firstly, you would need to launch Oracle SQL developer on your computer system.

Access the preferences

Now go to the menu bar at the top and click on tools there. From the drop-down menu, you should select preferences.

Navigate to the code editor fonts

In the preferences window, expand the code editor node on the left-hand side by just clicking the arrow next to it. Then click on the fonts.

Changes in the font size

On the right side of your hand, you will see an option for setting the font. Locate the font option.

Adjust font properties

In the font choosers dialogue box, you can select the desired font family, style, and even size. Here you can increase the font size by selecting a higher value.

Apply the changes

Click OK in the font chooser dialogue box to apply the changes. Then click OK again in the preferences window to save and apply the new setting.

Verify the changes

Now you can return to your SQL worksheet and then verify whether the don’t size has increased or not. The text should now be larger and more readable.

Here is a concise representation given in pseudo-code for the purpose of summarizing the steps:-

Function increaseFontSizeInSQLDeveloper() {
    Launch SQL_Developer
    Navigate to Tools -> Preferences
    Expand Code_Editor -> select Fonts
    Open Font_Chooser_Dialog (by clicking the “…” button)
    Set Font_Size to desired_value (e.g., change 12 to 16)
    Click OK to apply changes in Font_Chooser_Dialog
    Click OK to save changes in Preferences window
    Verify font size in SQL worksheet
}

Here is also the java based approach given of how you can modify the Configuration file to change the font size in Oracle-based SQL developer:-

Import java.io.*;
Import javax.xml.parsers.*;
Import org.w3c.dom.*;
Import org.xml.sax.SAXException;
Public class ChangeSQLDeveloperFontSize {
    Private static final String CONFIG_FILE_PATH = “path/to/your/sqldeveloper/configuration/product.conf”;
    Private static final String FONT_SIZE_PROPERTY = “ide.editor.fontSize”;
    Public static void main(String[] args) {
        Try {
            // Load the configuration file
            File configFile = new File(CONFIG_FILE_PATH);
            DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
            DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
            Document doc = dBuilder.parse(configFile);
            Doc.getDocumentElement().normalize();
            // Find the font size property node
            NodeList properties = doc.getElementsByTagName(“property”);
            Boolean fontSizeChanged = false;
            For (int I = 0; I < properties xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>


Your Answer