For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
2. Need to get the output in single query without using concatenation || for keyword 'oracle' in which ‘ace’ should in upper case and remaining ‘orl’ in lower case.