Change Case of quoted strings

[Quantum]

In R13 I open a window (Command, SQL Window, ...) and then I enter:

SELECT owner, synonym_name, table_owner, table_name FROM dba_synonyms WHERE synonym_name IN ('v$session', 'v$sesstat', 'v$statname');

Using the mouse I select the strings 'v$session', 'v$sesstat', 'v$statname' (including the single quote to the left of the leftmost string. Yes, it's important)
Select Edit on the ribbon and click on the uppercase icon "Convert selection to uppercase". The selected string is not converted to uppercase. Same result if the string was in uppercase and you were trying to convert it to lowercase.

In order to convert your string to uppercase/lowercase, do the following:
Select the string, but this time (yes, you guessed right) do not include the single quote of the leftmost string.
'v$session', 'v$sesstat', 'v$statname'

Given the following: in ('v$session', 'v$sesstat', 'v$statname');
If you select everything and hit uppercase, only the word "IN" is converted.

Thanks

 

[Marco Kalter]

That is indeed correct. The Uppercase Selection function does not affect text within quotes. To convert within quotes you can explicitly select it and use the Uppercase Selection function.