If you want to convert the values in the ename column of a table to uppercase in Oracle SQL, you can use the UPPER function. The UPPER function converts all characters in a string to uppercase. Here's an example query:
UPDATE your_table_name
SET ename = UPPER(ename);
also if we put number as input then it shoul show error
similar for Uppercase to lowercase