-Fixed length strings are also compared with blank-padded : Char Varchar Compare « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Char Varchar Compare

-Fixed length strings are also compared with blank-padded



SQL>
SQL> --Demonstration of string comparison semantics.
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2    fixed_length_10  CHAR(10);
  3    fixed_length_20  CHAR(20);
  4  BEGIN
  5    --Fixed length strings are also compared with blank-padded
  6    -- comparison semantic, so the fact that one is longer doesn't matter.
  7    fixed_length_10 := 'Donna';
  8    fixed_length_20 := 'Donna';
  9    IF fixed_length_20 = fixed_length_10 THEN
 10       DBMS_OUTPUT.PUT_LINE('Char: ' || fixed_length_10 || ' = ' || fixed_length_20);
 11    END IF;
 12
 13  END;
 14  /
Char: Donna      = Donna

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Constants are compared using blank-padded comparison semantics
2.Comparison of a fixed length string and a literal
3.Compare a variable length string with a fixed length, and the trailing spaces do matter
4.The maximum lengths of varchar2 strings do not matter