Informatics Practices
Explain the UCASE() SQL function using suitable examples.
SQL Queries
2 Likes
Answer
The UCASE()/UPPER() function converts the given string into uppercase. The syntax is UPPER(str) or UCASE(str). It returns the argument str with all letters capitalized, and the return value has the same data type as the argument str. For example,
SELECT UPPER('Large') "Uppercase";
Output
+-----------+
| Uppercase |
+-----------+
| LARGE |
+-----------+
Answered By
2 Likes
Related Questions
Assertion. The count(*) will yield a single value while round() will yield number of values equal to the cardinality of the table.
Reason. The count (*) is a multiple-rows function and round() is a single-row function.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
Define a function.
Explain the TRIM() SQL function using suitable examples.
Explain the MID() SQL function using suitable examples.