Skip to Main Content

SQL & PL/SQL

Announcement

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!

how to change uppercase to lowercase for alternative letter in oracle sql

User_YBZOVSep 26 2022 — edited Sep 26 2022

image.pngas shown in above I want all lowercase letter excluding 'A' as shown in excepted output
(In Oracle sql developer)
Write a query to display excepted output
Please find the Create table and Insert script for table 'LETTER'--
====================================================
CREATE TABLE LETTER (WORDS VARCHAR2(30));
INSERT INTO LETTER VALUES ('GAJARAJ');
INSERT INTO LETTER VALUES ('RAMARAJ');
INSERT INTO LETTER VALUES ('DEVARAJ');
COMMIT;
SELECT * FROM LETTER;

This post has been answered by Frank Kulash on Sep 26 2022
Jump to Answer
Comments
Post Details
Added on Sep 26 2022
4 comments
1,725 views