Toad World® Forums

How do you Capitalize Keywords?

I am using Toad for Data Analysts version I would like to capitalize the keywords.

Example: select
then automatically becomes

How can you get this functionality?

When you have an editor open, use the Edit | Advanced | Make Uppercase action.


In the regular Toad for Oracle, you can configure it so when you type select it automatically converts it to upper case. So, what you are telling me is in the version that I have, it must be done manually.

You can also use Format SQL Action. It is available from Editor toolbar or Main Menu. There are several format options. You can also create your own format rule.

hope that helps.


To automate this define it in your format options as Alexander mentions and run it through the Format SQL Action.