可以的SQL> select * from bb; BID BNAME
---------- ----------
1 张zhang
2 李li
3 王wang
4 孙sunSQL> select length(bname),length(lpad(' ',length(bname),' ')),replace(lpad(' ',length(bname),' '),' ','a') from bb;LENGTH(BNAME) LENGTH(LPAD('',LENGTH(BNAME),' REPLACE(LPAD('',LENGTH(BNAME),
------------- ------------------------------ --------------------------------------------------------------------------------
6 6 aaaaaa
4 4 aaaa
5 5 aaaaa
4 4 aaaaSQL>
---------- ----------
1 张zhang
2 李li
3 王wang
4 孙sunSQL> select length(bname),length(lpad(' ',length(bname),' ')),replace(lpad(' ',length(bname),' '),' ','a') from bb;LENGTH(BNAME) LENGTH(LPAD('',LENGTH(BNAME),' REPLACE(LPAD('',LENGTH(BNAME),
------------- ------------------------------ --------------------------------------------------------------------------------
6 6 aaaaaa
4 4 aaaa
5 5 aaaaa
4 4 aaaaSQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货