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