-
Notifications
You must be signed in to change notification settings - Fork 13
SQL capitalization column
shenhuan2021 edited this page Mar 3, 2024
·
3 revisions
- gfmtopt.case_column_name, type of TCaseOption
- TODO
- Column name has a dedicated case option.
Option: fmt106_case_column_name = upper, type: TFmtCase.
SELECT DEPARTMENT_ID,
Min( SALARY )
FROM employees
GROUP BY DEPARTMENT_ID
User can also specify a column mapping file that all columns should be capitalized exactly the same as the one in this file. Column name in this mapping file should be one column per line with desired case. If column name is not found in this mapping file, then case option for column name applied.