datatype_char_varchar2
Objectives:
  • blank padding in character data-type
  • the value assigned with empty space from system/db ,are trimmed by default and report the siring length.
  •   values from char to varchar2, the later preserved the former (char), char(10) with 5 character + space were added tovarchar2.
Code ;

declare
v_char char(10):='MANAS';
v_var1 varchar2(20):='1234567 ';
v_var2 varchar2(7):='88888';
BEGIN
DBMS_OUTPUT.PUT_LINE('1. varchar (20)*'||v_var1||'*'|| length(v_var1));
DBMS_OUTPUT.PUT_LINE('2. v_char(10)*'||v_char ||'*'||length(v_char));
v_var1:=v_char;
DBMS_OUTPUT.PUT_LINE('3. v_var1:=v_char*'||v_var1||'*'|| length(v_var1));
DBMS_OUTPUT.PUT_LINE('4. *'||v_var1||'*'||v_char ||'*'||v_var1||'*');
v_char :=v_var2;
DBMS_OUTPUT.PUT_LINE('5. v_char :=v_var2 *'||v_char ||'*'||length(v_char));
END;
/