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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center