Oracle normally requires double-quotes to delimit the name of identifiers in SQL statements, e.g.
SELECT"MyColumn"AS"MyColAlias"FROM"MyTable"AS"Alias"WHERE"ThisCol"='That Value';
However, it graciously allows omitting the double-quotes, in which case it quietly converts the identifier to uppercase:
SELECT MyColumn AS MyColAlias
FROM MyTable AS Alias
WHERE ThisCol ='That Value';
gets internally converted to something like:
SELECT"ALIAS"."MYCOLUMN"AS"MYCOLALIAS"FROM"THEUSER"."MYTABLE"AS"ALIAS"WHERE"ALIAS"."THISCOL"='That Value';