select rpad( '*', 5, '*' ) : RPAD « Char Functions « Oracle PL / SQL






select rpad( '*', 5, '*' )

  
SQL>
SQL>
SQL> select rpad( '*', 5, '*' )
  2  from dual
  3  /
RPAD(
-----
*****

1 row selected.

SQL>
SQL> --

   
  








Related examples in the same category

1.Rpad: makes a string a certain length by adding (padding) a specified set of characters to the right
2.LPAD() and RPAD(): pad the input parameter of character data types with blanks (or another character) from the left or right
3.RPAD() function's behavior is identical to that of LPAD(), the only difference being the padding side.
4.Use rpad to add extra space
5.Padding department with < and >