SQL_Lower2

Note :The function "initcap" is not support by MySQL, one of the way around is shown below

SQL Script:

SELECT empno, ename , lower(ename)"L-ENAME", initcap(ename)"I-ENAME" FROM emp WHERE ROWNUM < 7

PostgreSQL

SELECT empno, ename , lower(ename)"L-ENAME", initcap(ename)"I-ENAME" FROM emp LIMIT 6

MYSQL:

SELECT empno, ename , lower(ename)"LW-NAME", LEFT(ENAME,1)"LT-ENAME" FROM emp LIMIT 6

ORACLE

POSTGRESQL:

mysql