ORACLE LPAD()函数
LPAD(原始字符,填充后长度,填充字符)参考这篇帖子填充字符不写默认填充空格SQLselect Lpad('ABCDEFG',4) from dual结果SQLselect Lpad('ABCDEFG',10,'-') from dual结果SQLselect Lpad(level, 2, 0) as month from dual connect by level <13结果Lpad 不是 Ipad 这几天同事让我帮他写几张视图,有一个需求是要按月份
原创
2020-05-17 11:29:23 ·
6025 阅读 ·
0 评论