SQL> -- Comparison of CHAR with VARCHAR2.
SQL>
SQL> SET SERVEROUTPUT ON
SQL> SET ECHO ON
SQL>
SQL> DECLARE
2 employee_name_c CHAR(32);
3 employee_name_v VARCHAR2(32);
4 BEGIN
5 -- Assign the same value to each string.
6 employee_name_c := 'String';
7 employee_name_v := 'String';
8
9 -- Test the strings for equality.
10 IF employee_name_c = employee_name_v THEN
11 DBMS_OUTPUT.PUT_LINE('The names are the same');
12 ELSE
13 DBMS_OUTPUT.PUT_LINE('The names are NOT the same');
14 END IF;
15 END;
16 /
The names are NOT the same
PL/SQL procedure successfully completed.
SQL>