User has a query with a sting in it. When changing the query to lower case, the string also got changed. This is an undesirable effect because the sting could be a sentence.
For example:
SELECT 'Joe works for Quest Software' FROM DUAL
Because the string is a sentence you cannot have the result be "joe works for quest software" where the names and the first letter of a sentence are in lower case.
WORKAROUND:
None.
STATUS:
Issue fixed in version 9.1. The latest version of Toad for Oracle can be downloaded here.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center