Comparison of a fixed length string and a literal : Char Varchar Compare « PL SQL « Oracle PL / SQL






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

Comparison of a fixed length string and a literal

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
  8    --Comparison of a fixed length string and a literal also
  9    -- results in the use of blank-padded comparison semantics.
 10    IF fixed_length_10 = 'Donna' THEN
 11       DBMS_OUTPUT.PUT_LINE('Char and constant:' || fixed_length_10 ||' = ' || 'Donna');
 12    ELSE
 13       DBMS_OUTPUT.PUT_LINE('Not Donna');
 14    END IF;
 15  END;
 16  /
Not Donna

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Constants are compared using blank-padded comparison semantics
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