Constants are compared using blank-padded comparison semantics
SQL>
SQL> -- Demonstration of string comparison.
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 --Constants are compared using blank-padded comparison semantics,
8 -- so the trailing spaces won't affect the result.
9 IF 'Abc' = 'Abc ' THEN
10 DBMS_OUTPUT.PUT_LINE('Constant: ''Abc'' = ''Abc ''');
11 END IF;
12
13 END;
14 /
Constant: 'Abc' = 'Abc '
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category