The maximum lengths of varchar2 strings do not matter : Char Varchar Compare « PL SQL « Oracle PL / SQL






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

The maximum lengths of varchar2 strings do not 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     --the maximum lengths of varchar2 strings do not matter,
  8     --only the assigned values.
  9     var_length_10 := 'Donna';
 10     var_length_20 := 'Donna';
 11     IF var_length_20 = var_length_10 THEN
 12       DBMS_OUTPUT.PUT_LINE('Both Varchar2:' || var_length_20 ||' = ' || var_length_10);
 13     ELSE
 14       DBMS_OUTPUT.PUT_LINE('Both Varchar2:' || var_length_20 ||' NOT = ' || var_length_10);
 15     END IF;
 16  END;
 17  /
Both Varchar2: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.-Fixed length strings are also compared with blank-padded
4.Compare a variable length string with a fixed length, and the trailing spaces do matter