Case Sensitivity Practice Using UPPER() and LOWER() Functions

UPPER() #

Converts all input character data to uppercase.

SELECT UPPER('CodeLion') FROM DUAL; # CODELION

LOWER() #

Converts all input character data to lowercase.

SELECT LOWER('CodeLion') FROM DUAL; # codelion

Find members whose ID is 'codelion', case-insensitively.

SELECT * FROM MEMBER WHERE ID = UPPER('codelion')