How do you Capitalize Keywords?

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

Example: select
then automatically becomes
SELECT

How can you get this functionality?

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

Debbie

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.

Alex

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

Debbie