Mega Code Archive
The maximum lengths of varchar2 strings do not matter, only the assigned values
<![CDATA[
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 var_length_10 := 'ZZZZ';
10 var_length_20 := 'ZZZZ';
11 IF var_length_20 = var_length_10 THEN
12 DBMS_OUTPUT.PUT_LINE('Both Varchar2: '''
13 || var_length_20 || ''' = '''
14 || var_length_10 || '''');
15 ELSE
16 DBMS_OUTPUT.PUT_LINE('Both Varchar2: '''
17 || var_length_20 || ''' NOT = '''
18 || var_length_10 || '''');
19 END IF;
20 END;
21 /
Both Varchar2: 'ZZZZ' = 'ZZZZ'
PL/SQL procedure successfully completed.
SQL>
]]>