Background

Let us begin the process of customizing our SQL Developer Editor.

Outline

1. Preference
   • Tabs Versus Spaces
   • Show White Spaces

Tasks

Preferences

Preference – Tabs Versus Spaces

Outline

1. Access Menu
   • Access the Menu and select Tools and Preferences
2. In the Preferences Window
   • Within the left navigator tree, access the options Code Editor / Format / Advanced Format
   • Within the group box Indentation
     • Indent Spaces
       • Please enter the number of space characters
     • Indent With
       • Choose one of the options listed below
         • Tabs
         • Spaces

Images

Image – Preferences – Code Editor – Format – Advanced Format

 

Preference – Tabs Versus Spaces

Outline

1. Access Menu
   • Access the Menu and select Tools and Preferences
2. In the Preferences Window
   • Within the left navigator tree, access the options Code Editor / Display
   • Review the “Show Whitespace Characters” option

View

Let us review the sample editor contents

View – Tabs

Here is what Tabs look like ( when whitespaces are shown ):-

1. Tabs
   • Tabs – 01
     Link

View – Spaces

Here is what spaces look like ( when whitespaces are shown ):-

1. Spaces
   • Spaces – 01
     Link

Images

Image – Preferences – Code Editor – Display

 

Image – Sample – Editor – Tabs

Sample 01

Image – Sample – Editor – Spaces

Sample 01

 

References

1. Jeff Smith
   • That Jeff Smith
     • How To: Configure TABs in SQL Developer
       Link
     • Tabs in your Code
       Link
2. Stack Overflow
   • Alex Poole
     • Unwanted sign on each line of worksheet
       Link