Toad World® Forums

Options for Oracle SQL output / preview


#1

I like to define my columns in lower case as it is horrible to read ALL_CAPS ALL THE TIME. Anyhow it looks like all the SQL generation is including quotation marks which would force scripts to create lowercase columns which is not good.

How do I turn this off?

thanks

jack


#2

Hi,

when you generate SQL code (F9), on tab Detailed Settings there is checkbox Use Quotation Marks (first check box). This doesn’t affect names where you manually add quotation marks, e.g. check contraints definitions.

Regards,

Vaclav