Informatics Practices
What will be the output of following code ?
mysql> SELECT UCASE('Computer studies');
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'.
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'