Constants are compared using blank-padded comparison semantics : Char Varchar Compare « PL SQL « Oracle PL / SQL






Constants are compared using blank-padded comparison semantics


SQL>
SQL> -- Demonstration of string comparison.
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    --Constants are compared using blank-padded comparison semantics,
  8    -- so the trailing spaces won't affect the result.
  9    IF 'Abc' = 'Abc          ' THEN
 10       DBMS_OUTPUT.PUT_LINE('Constant: ''Abc'' = ''Abc          ''');
 11    END IF;
 12
 13  END;
 14  /
Constant: 'Abc' = 'Abc          '

PL/SQL procedure successfully completed.

SQL>
           
       








Related examples in the same category

1.Comparison of a fixed length string and a literal
2.-Fixed length strings are also compared with blank-padded
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