I have a business requirement to convert all data to caps in the output process to excel. This could also work by converting the text in the data grid prior to exporting. I see lots aof assistance in converting sql statements to all caps and also converting specified words to caps, but I am struggling to find a command that will convert all data to caps. Anyone out there have any suggestions?
select upper(col1), upper(col2) … from table_name
dbms_output.put_line(UPPER(‘your output value as string’));