SELECT ename,
LOWER (SUBSTR (ename, 1, ROUND (LENGTH (ename) / 2)))
|| UPPER (SUBSTR (ename, ROUND (LENGTH (ename) / 2) + 1, LENGTH (ename)))
a
FROM emp;
LOWER (SUBSTR (ename, 1, ROUND (LENGTH (ename) / 2)))
|| UPPER (SUBSTR (ename, ROUND (LENGTH (ename) / 2) + 1, LENGTH (ename)))
a
FROM emp;