SELECT empno,ename "U-name", lower(ename)"L-name" from emp where rownum <7
PostgreSQL and MySQL
SELECT empno,ename "U-name", lower(ename)"L-name" from emp limit 6
| SQL_lower1.htm |
Oracle:
PostgreSQL and MySQL
|
| All three database prints column name in uppercase |
| Oracle:
|
| PostgreSQL
|
| MySQL
|