Toad World® Forums

Toad Version 12.1 How do I convert the output of a query to all caps?


#1

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?


#2

select upper(col1), upper(col2) … from table_name


#3

or
dbms_output.put_line(UPPER(‘your output value as string’));
or
dbms_output.put_line(UPPER(some_var));