Informatics Practices

What will be the output of following code ?

mysql> SELECT UCASE('Computer studies');

SQL Queries

1 Like

Answer

+---------------------------+
| UCASE('Computer studies') |
+---------------------------+
| COMPUTER STUDIES          |
+---------------------------+

Working

The UCASE() function in SQL is used to convert all characters of a given string to uppercase. In this query, UCASE('Computer studies') converts the entire string to 'COMPUTER STUDIES'. Therefore, the output is 'COMPUTER STUDIES'.

Answered By

3 Likes


Related Questions