select en
ame,sal,job
From emp where sal > 2500 union select ename,sal,job f
rom emp where job = 'MANAGER';
select lower(ename),sal from em
p; <
PRE class=sql name="code">select lower(substr(ename,2,length(ename)-1)) from emp;</PRE><
br>
然后将两个结果合并,则得到了要显示的内容:
<PRE></PRE>
<PRE class=sql name="code" sizcache="0" sizset="11"><PRE class=sql name="code">select upper(substr(ename,1,1))||lower(substr(ename,2,length(ename)-1)) as name from emp;</PRE><BR>
替换函数replace
<PRE></PRE>
<PRE class=sql name="code" sizcache="0" sizset="14"><PRE class=sql name="code">select replace(ename,'A','我') from emp;</PRE><BR>
<BR>
<BR>
<PRE></PRE>
</PRE></PRE>