Is there a setting for file geodatabases to force column names in UPPER or LOWER CASE?

Question

I generate feature layers from subsets of data stored in an Oracle database. After some adjustments to the data, such as deleting columns, adding columns and calculating their values I am writing the feature classes into a file geodatabase.

Looking at the column names generated by ArcGIS Pro I am puzzled that auto-generated columns e.g. GEOMETRY_Length have mixed names. Worst, I cannot alter the field name since the field is required...

* How to adjust/avoid mixed naming?
* How to force column names to UPPER CASE?

RobertBorchert · Answer

The names you see in Oracle are most likely and Alias.  The names that are coming out of the database are the actual names of the column in the Oracle database.

If you want to change the way the column names look you will need to create and alias. or generate  the table the way you want it as a template and load the data to that table.

To make a permanent change you would need to go into the Oracle database and change the actual names.

I WOULD NOT RECOMMEND DOING THAT

TomGeo · Answer

Not as long as we are within the environment of ArcGIS Pro. It gives us some trouble since we cannot control it with respect to the demands coming from the site of the RDBMS. The latter one is not ours and we have to live up to the column naming definition, so the data import can proceed in a standardized way.

George_Thompson · Answer

Is the mixed case causing any issues, errors, etc?