SESSION NAME: SQL Functions - 2.
QUESTION NAME: LCASE - LOWER.
TABLE DESCRIPTION:
Write a function to convert all the names in the column to
lower case.
Table Name : emp
Columns
eid - Number
name - varchar
age - Number
salary - Number
Note: LCASE function is similar to LOWER function.
Use LOWER Function
lower case.
Table Name : emp
Columns
eid - Number
name - varchar
age - Number
salary - Number
Note: LCASE function is similar to LOWER function.
Use LOWER Function
CODE:
select lower(name) from emp;
0 Comments