Changing from Lower case to Upper case in Apex
910000Apr 5 2012 — edited Apr 5 2012Hi,
I am using Apex 3.2 on Oracle 11g.
I have uploaded lots of data to a Configuration Management Database, developed using Apex 3.2
However, in a field called 'Hostname', some hosts are shown in Upper case and some hosts are shown in Lower case.
As there are 100's of hosts, its a hectic task to change each host in lower case to upper case manually.
Is there a way using which I can convert all hosts in lower case to upper case all at one shot?
Any help would be highly appreciated.
Thanks in advance.
Regards
Sharath