The UPPER function allows you to convert all lowercase letters in a string to uppercase.
SELECT UPPER('My text 123!') AS result FROM dual;
Output:
RESULT ------------ MY TEXT 123!