SQL>
SQL> SET ECHO ON
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
9
10 fixed_length_10 := 'ZZZZ';
11 fixed_length_20 := 'ZZZZ';
12 IF fixed_length_20 = fixed_length_10 THEN
13 DBMS_OUTPUT.PUT_LINE('Char: ''' || fixed_length_10 || ''' = '''
14 || fixed_length_20 || '''');
15 END IF;
16
17 END;
18 /
Char: 'ZZZZ ' = 'ZZZZ '
PL/SQL procedure successfully completed.
SQL>