PAD

I made my speech longer by padding it with a few jokes;

Ipad2,Ipad3 and so on.

Now Let's get to the pad of the  Oracle® Database SQL Reference:

1 left Pad：

SQL>  select lpad('Michaelyang',22,'My name is ') from dual;

LPAD('MICHAELYANG',22,
----------------------
My name is Michaelyang

2  right Pad：

SQL>  select rpad('My name is ',22,'Michaelyang') from dual;

RPAD('MYNAMEIS',22,'MI
----------------------
My name is Michaelyang

 

------end-------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-718825/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-718825/