使用单行字符型函数的实例

例4-15

SQL> SELECT empno AS "Code",UPPER(ename) NAME,INITCAP(job) "Job"

2 FROM emp

3 WHERE LOWER(job)='salesman';