yydcdut@Android笔记

摘要： 向左补全字符串lpad(字段名,填充长度,填充的字符)select lpad('1',4,'0') from dual;向右补全字符串rpad(字段名,填充长度,填充的字符)select rpad('1',4,'0') from dual;返回字符串小写select lower('STUDENT') from dual;返回字符串大写select upper('admin') from dual;单词首字符大写select initcap('admin') from dual;返回字 阅读全文