/*将姓名的首字母使用大写，而其余使用小写*/
/*方法一*/
select upper(substr(‘zhangjie',1,1))||lower(substr(‘zhangjie',2,length(‘zhangjie'))) from dual;
/*方法二*/
select initcap(‘zhangjie') from dual;