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