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
What will be the output of following code ?
mysql> SELECT CONCAT(CONCAT('Inform', 'atics'), 'Practices');What will be the output of following code ?
mysql> SELECT LCASE('INFORMATICS PRACTICES CLASS 11TH');What will be the output of following code ?
mysql> SELECT CONCAT(LOWER('Class'), UPPER('xii'));If Str = "INFORMATICS PRACTICES …." and Str1 = "… FOR CLASS XI"
Write commands to print the output as 'informatics practices for class xi'