Informatics Practices
What will be the output of following code ?
mysql> SELECT LCASE('INFORMATICS PRACTICES CLASS 11TH');
SQL Queries
2 Likes
Answer
+-------------------------------------------+
| LCASE('INFORMATICS PRACTICES CLASS 11TH') |
+-------------------------------------------+
| informatics practices class 11th |
+-------------------------------------------+
Working
The LCASE() function in SQL is used to convert all characters of a given string to lowercase. In the query, LCASE('INFORMATICS PRACTICES CLASS 11TH') converts the entire string to 'informatics practices class 11th'. Therefore, the output is 'informatics practices class 11th'.
Answered By
1 Like
Related Questions
Explain the POWER() SQL function using suitable examples.
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 UCASE('Computer studies');What will be the output of following code ?
mysql> SELECT CONCAT(LOWER('Class'), UPPER('xii'));