datatype_char_varchar2B,htm |
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;
/
|
|
|
|