语法:UPPER(列、字符串)
LOWER(列、字符串)
SCOTT@itkaifang> SELECT UPPER(ename),ename FROM emp; UPPER(ENAM ENAME ---------- ---------- SMITH SMITH ALLEN ALLEN WARD WARD JONES JONES MARTIN MARTIN BLAKE BLAKE CLARK CLARK SCOTT SCOTT KING KING TURNER TURNER ADAMS ADAMS JAMES JAMES FORD FORD MILLER MILLER 14 rows selected. SCOTT@itkaifang> SELECT LOWER(ename),ename FROM emp; LOWER(ENAM ENAME ---------- ---------- smith SMITH allen ALLEN ward WARD jones JONES martin MARTIN blake BLAKE clark CLARK scott SCOTT king KING turner TURNER adams ADAMS james JAMES ford FORD miller MILLER 14 rows selected. SCOTT@itkaifang>