0

I'm using Toad to write queries agains an Oracle database. When I write table_name. I get an auto-suggestion menu with all the column names. But if I choose a column name, both the table name and column name is written by uppercases. Is there any way to change this to be written in lowercases instead?

In View > Formatting Option > Case "Identifiers" are set to Lowercase

2 Answers 2

2

I found the following on Quest.com. It works, but may have undesirable side effects.

  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 on the left hand side, select "Indentifer" and select Lowercase for Capitalization effect on the right hand side.
  5. Under styles on the left hand side, select "Toad_user_table" and select Lowercase for Capitalization effect on the right hand side..
  6. Click on Apply and OK.
1
  • I'm surprised this was accepted. It appears to change the capitalization in the code as well as in the list. Commented Apr 6, 2016 at 14:42
-1

Click on the following menu items:

View -> toad options -> Editor -> Behaviour

Then check Use lowercase object names from select windows

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.