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 BEGIN
5 --Fixed length strings are also compared with blank-padded
6 -- comparison semantic, so the fact that one is longer doesn't matter.
7 fixed_length_10 := 'Donna';
8 fixed_length_20 := 'Donna';
9 IF fixed_length_20 = fixed_length_10 THEN
10 DBMS_OUTPUT.PUT_LINE('Char: ' || fixed_length_10 || ' = ' || fixed_length_20);
11 END IF;
12
13 END;
14 /
Char: Donna = Donna
PL/SQL procedure successfully completed.
SQL>