Compare a variable length string with a fixed length, and the trailing spaces do matter : Char Varchar Compare « PL SQL « Oracle PL / SQL






Compare a variable length string with a fixed length, and the trailing spaces do matter


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    var_length_10    VARCHAR2(10);
  5    var_length_20    VARCHAR2(20);
  6  BEGIN
  7
  8    -- Compare a variable length string
  9    -- against a fixed length, and the
 10    -- trailing spaces do matter.
 11    var_length_10 := 'Donna';
 12    IF fixed_length_10 = var_length_10 THEN
 13      DBMS_OUTPUT.PUT_LINE('Char and Varchar2:'
 14                            || fixed_length_10 ||' = '
 15                           || var_length_10 );
 16    ELSE
 17      DBMS_OUTPUT.PUT_LINE('Char and Varchar2: '
 18                            || fixed_length_10 ||' NOT = '
 19                            || var_length_10);
 20    END IF;
 21
 22  END;
 23  /
Char and Varchar2:  NOT = 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.-Fixed length strings are also compared with blank-padded
4.The maximum lengths of varchar2 strings do not matter