Selecting all uppercased-value rows of a table in SQL Navigator

Question

I have a table with an email address column. Some email addresses in the table contain uppercase letters. I would like to fetch all the rows with uppercase emails (in order to set them to lowercase). How do I select all the rows where the email address contains uppercase letters?

score 5 · Accepted Answer · edited May 23 '17 at 10:25

5

I believe Oracle is case sensitive by default? If so, then this should work:

SELECT *
FROM table_name
WHERE LOWER(email) <> email

If this works then you can simply update them with

UPDATE table_name
SET email = LOWER(email)
WHERE LOWER(email) <> email

edited May 23 '17 at 10:25

Community

1
1

answered Nov 05 '12 at 10:29

Richard

28,666
8
72
117

Damn, you were a minute faster :P – d33tah Nov 05 '12 at 10:31
1

@d33tah - a minute is too long time between answers here in SO :P – Mahmoud Gamal Nov 05 '12 at 10:33

Selecting all uppercased-value rows of a table in SQL Navigator

1 Answers1