Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Comparison of CHAR with VARCHAR2 (Test the strings for equality)

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>