Toad World® Forums

Case of table aliases


#1

I want this when I format a SQL statement.

SELECT D.dummy FROM DUAL D;

But when I format the statement, with Oracle Formatter Options > Case > Identifiers : Lowercase, I get this.

SELECT d.dummy FROM DUAL d;

Notice the table aliases are lowercase and apparently must be considered an identifier (and probably rightfully so).

Is there a way to keep the identifiers as lowercase but make the table aliases uppercase, or maybe not change the case of the table alias at all and use however it’s defined throughout the rest of the formatted statement?

If not, can there be a way? I guess if no table alias is defined and a column is referenced with the table name as a prefix (e.g. DUAL.dummy) the prefix should still be considered an identifier.

Thanks!

-Rick

P.S. Just installed 10.5. So far so good.