Search This Blog

Monday, April 1, 2013

How to have Capitalization Effects (uppercase / lowercase) in Toad for Oracle v9

Use the Language Management tool to customize editor behavior for reserved words:

Toad for Oracle 9.0 to 9.5:

 1. Go to View | Toad Options in the main menu.
 2. On the left-hand side of the options window go to Editor | Behavior.
 3. Under the Language section, highlight PL/SQL (default) and then click the Edit button.
 4. In the Language Management window, click the Highlighting tab.
 5. Under styles, select Reserved word.
 6. For the Capitalization effect use the drop-down list to select desired behavior.

Toad for Oracle 9.6.1 and above:

 1. Go to View | Toad Options in the main menu.
 2. On the left-hand side of the options window go to Editor | Behavior.
 3. Under the Language section, click on the Syntax highlighting button.
 4. In the new window, under styles, select Reserved word.
 5. For the Capitalization effect use the drop-down list to select desired behavior.

No comments:

Post a Comment