Toad World® Forums

Casing Rules In Formatter


#1

We unfortunately have column names in tables and views that are the same name as
built-in functions. They’re being formatted as all upper case. But since
they’re column names, I’d rather they were made lower case. Is there
a way to disambiguate this situation? Maybe a formatter option to override the
case rule for built-in functions when they’re also column names?

For example, group_id() is a built-in SQL function. But without the parentheses
it’s a common column name in our schema.

Dan Clamage

Oracle Database Developer

Join Confluence and your industry peers for the 2011 Client Conference,
Innovation, Best Practices and the Bottom Line, May 15 – 17 in Pittsburgh,
PA. Go to www.confluence.com/clientconference to register today.

C O N F L U E N C E

412.246.1806 direct

412.802.8632 main

412.802.8647 fax

THE MATERIAL CONTAINED IN THIS MESSAGE IS CONFIDENTIAL AND IS SUBJECT TO
RESTRICTIONS ON ITS DISCLOSURE. The recipient acknowledges that the information
contained herein is the exclusive, proprietary and confidential property of
Confluence Technologies, Inc. and shall be at all times regarded, treated and
protected as such by the recipient. The use and disclosure of this information
is subject to the restrictions contained in the Software License Agreement
between the recipient (or the recipient’s employer or its affiliates) and
Confluence Technologies, Inc.