Oracle lpad and rpad

In the PL/SQL test window

-- Created on 2005-7-3 by tangtian
Declare
-- Local variables here
I integer; leftpad varchar (11 );
Rightpad varchar (14 );
Begin
-- Test statements here
Select lpad ('Hello! ', 8, 'tangtian'), rpad ('Hello! ', 8, 'tang') into leftpad, rightpad from dual;
Dbms_output.put_line (leftpad | ''| rightpad );
End;

Execution result

Background: tahello!In the preceding stringAdd the string to the leftUntilPreviousThe string length is equal to the intermediate parameter 8..

hello! Ta In the string 1 2 until the length of string 1 is equal to I